Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi first time posting but have been struggling with this for too long.
I have a large table with the following
ID | Status
1 Above Budget
2 Below Budget
3 Above Budget
4 Above Budget
The status column is a measure based off the delta between two other columns. It needs to be a measure, as I need this Status calculated dynamically based on the filter/slicer selections on the page.
If I select a table, the measure shows up correctly for each record.
But what I need is a pie chart off this table that would show 75% Above Budget and 25% Below Budget
Since I cannot use measure in the legend of the chart I have tried to create two separate measures, one for Above Budget and another for Below Budget. However, the result I am getting is NOT accurate, I am seeing 4 show up for both Above Budget and Below Budget, likely due to the various granularity of my data.
I have tried various iterations of the below DAX, including sum the forecast and budget but result is always incorrect
Any ideas on how to get the correct values to show up?
Solved! Go to Solution.
Hi @novice12
You can try these 3 measures :
The PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @novice12
You can try these 3 measures :
The PBIX is attached
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
144 | |
75 | |
63 | |
51 | |
48 |
User | Count |
---|---|
204 | |
86 | |
64 | |
59 | |
56 |