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.
Hello, I have been trying to use a Gauge chart to show the summarized data for each week using Slicer. The problem is
1. (Picture 1) Gauge show x2 of Data (356) instead of 178
2. (Picture 2) When I filter dates and category it can't show summarized data of each category in gauge, but show only the filtered value. I want to show 131 / 178
In this picture, gauge show 178 of 356 Data
Is there a way to be able to solve this problem?
DateCategoryData
19/7/2566 | A | 1 |
20/7/2566 | A | 3 |
25/7/2566 | B | 4 |
26/7/2566 | C | 5 |
27/7/2566 | A | 6 |
28/7/2566 | A | 7 |
28/7/2566 | B | 4 |
28/7/2566 | A | 10 |
29/7/2566 | C | 3 |
1/8/2566 | A | 50 |
3/8/2566 | B | 30 |
4/8/2566 | A | 70 |
4/8/2566 | A | 1 |
4/8/2566 | B | 5 |
4/8/2566 | C | 3 |
4/8/2566 | B | 9 |
4/8/2566 | A | 10 |
Solved! Go to Solution.
Hi, @ULtimateG
You can try the following methods.
Measure:
Max = CALCULATE(SUM('Table'[Data]),FILTER(ALL('Table'),[Date].[Month]=SELECTEDVALUE('Table'[Date].[Month])))
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @ULtimateG
You can try the following methods.
Measure:
Max = CALCULATE(SUM('Table'[Data]),FILTER(ALL('Table'),[Date].[Month]=SELECTEDVALUE('Table'[Date].[Month])))
Is this the result you expected?
Best Regards,
Community Support Team _Charlotte
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
This solution works fine, thanks.
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 |
---|---|
97 | |
97 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |