Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
I have a single dataset that has table called "reservations", which is presented in a BI report as a simple table. In this table it has a column called "buildings". Each building has a maximum capacity number (not contained in the table) which is hard set and can be included in the measure (if that makes sense to).
I want a measure to count the rows for each building in the table i.e London so that when a slice is set in the report to filter the table by building, and to define a maximum value for the guage which is building specific.
We're just using a simple measure to count the rows displayed in the table today which is applied to the guage:
Measure1 = COUNTROWS(reservations)
Solved! Go to Solution.
Hi,
According to your description, I can clearly understand your requirement, you want to create a gauge chart to display the comparison between your maximum capacity number and current capacity number, right? I think you can achieve your requirement by creating some measures like this:
This is the test data I created based on your description:
maximum capacity number =
MAX('reservations'[capacity number])
Current capacity numbers = COUNT(reservations[buildings])
Max = maxX(ALL(reservations),[capacity number])
Min = 0
And you can create a gauge chart and place it like this, then you can get what you want, like this:
You can download my test pbix file below
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi,
According to your description, I can clearly understand your requirement, you want to create a gauge chart to display the comparison between your maximum capacity number and current capacity number, right? I think you can achieve your requirement by creating some measures like this:
This is the test data I created based on your description:
maximum capacity number =
MAX('reservations'[capacity number])
Current capacity numbers = COUNT(reservations[buildings])
Max = maxX(ALL(reservations),[capacity number])
Min = 0
And you can create a gauge chart and place it like this, then you can get what you want, like this:
You can download my test pbix file below
Thank you very much!
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@shaun-bi
Do you need a new measure to get the capacity number based on the currently filtered building ? How about a new measure?
MaxValue = SELECTEDVALUE (reservations[capacity number]) , 0 )
or
MaxValue = MAX(reservations[capacity number])
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
@shaun-bi Maybe:
Max Measure =
VAR __Building = MAX('Table'[Building])
RETURN
SWITCH(__Building,
"Building1",44,
"Building2",33,
...
)
Thanks, this sets the maximums perfectly.
How do I combine that with the countrows to compare the table data to the maximum value. As right now, the gauge is just displaying the maximum values.
I've used BI for 2 hours only so sorry for the newbie questions!
User | Count |
---|---|
53 | |
46 | |
19 | |
16 | |
15 |
User | Count |
---|---|
113 | |
45 | |
44 | |
28 | |
22 |