Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Apps - Power Query
Unanswered

BI Newbie questions! Simple pie chart

(0) ShareShare
ReportReport
Posted on by 373

Hi,

 

I've been working on PowerApps for a few months now but I'm starting on Power BI now and have a couple of (what are probably) basic questions.

 

For my PowerApp, I have a table of Assets owned by clients. Each Asset has an Asset Category field, and there are 7 possible categories.

 

To my simple brain, if I select a Pie chart and select the Asset Category field, this should show me what proportion of all the assets registered are Asset Category 1, Asset Category 2 etc. However this doesn't show anything. What am I missing? Why doesn't the  visual show % against the sum of all assets?

 

thanks,

 

Martin

  • Martin_W Profile Picture
    373 on at
    Re: BI Newbie questions! Simple pie chart

    Hi,

     

    I've been away from this for a while.

     

    I now have a chart that looks like this:

    Martin_W_0-1663176692601.png

    The titles for the slices is obviously pulled from the field, but the only valid values in the dataset are "Asset Category 1" through "Asset Category 6". The title "Blank" has been selected by PowerBI by default so we can see that the number of assets which have not yet been categorised is 46.

     

    How can I change "Blank" to something else, like "Not Categorised"? There doesn't seem to be any option to change the names of the values as they appear in the chart?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Power Apps - Power Query

#1
mmbr1606 Profile Picture

mmbr1606 9 Super User 2025 Season 1

#2
SD-13050734-0 Profile Picture

SD-13050734-0 6

#3
Jon Unzueta Profile Picture

Jon Unzueta 2

Overall leaderboard

Featured topics