Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All
I need to create a KPI dashboard where I calculate two KPI's (power BI file and Excel attached):
1) % of "Done" workshops per division
2) % of "Done" reviews per division
I have two questions:
1) When I create the Gauge chart, it always just doubles the number of entries it found in the total, instead of counting the total number of entries. How do I fix that? Example: if I select only "Workshop" and status only "Done", it should show 8 records from 72 records. But it shows 8 records from 16 records.
2) How do I change it to percentage? If I cnahge to "percent of grand total", it always shows me 100%.
Files are here:
https://drive.google.com/drive/folders/1FzUurRAjTORWHFv-WM5pPx9pZqBzx8nm?usp=sharing
Thanks for you help!
Natalia
Solved! Go to Solution.
@natalia88 see attached hope it helps. you have to create a measure to assign the target and also added a card visual for %
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
Heres the link https://drive.google.com/drive/folders/1Q-GXNEfHIurDCMVfJCDdGc2H-BYO67Wc?usp=sharing
Help when you know. Ask when you don't!
That one was fun.
Help when you know. Ask when you don't!
@natalia88 see attached hope it helps. you have to create a measure to assign the target and also added a card visual for %
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
I was too qiuck! It's working fine, but the problem now is that if I click on one Division, I want the target to also show per Division. I.e. for Div1, it should be 4 out of 18 instead of 4 out of total 72. And for two divisions, it should be "Nr of "Done" from 18x2, etc
Is it possible?
@natalia88 change you target measure to
Target =
CALCULATE(
COUNTROWS( Table13 ),
ALLEXCEPT( Table13, Table13[Divusion] )
)
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
thank you! And sorry if I'm asking easy questions, I just started in PB...
it works now, but if there're no entries (i.e. all "N/A"), then the target is "blank" - any chance it can be fixed?
(I have a filter on status, if it makes any difference)
@natalia88 what you want the target in that case? If you want target to be zero, add 0 to the target measure
Target = CALCULATE( COUNTROWS( Table13 ), ALLEXCEPT( Table13, Table13[Divusion] ) ) + 0
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
hi Parry, 0 won't work because the target should be 36 if no division is selected and 9 if one division is selected (independent of whether it has anything "Done" or not, as it's the total number of workshops/reviews in each separate division).
Thanks a lot! Worked like a charm!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
100 | |
80 | |
64 | |
57 |
User | Count |
---|---|
146 | |
110 | |
93 | |
84 | |
67 |