Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
User | Count |
---|---|
127 | |
108 | |
100 | |
63 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |