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,
I have an arrears line chart and its a percentage of the total book each month, i only want to show 3 arrears categories againset the total and allow for filter of areas. if I filter the lines out the percentages change. Is there a way to hide an line so percentages don't change
Thanks
Solved! Go to Solution.
Hi @Denismc ,
Based on my testing, please try the following methods:
1.Create the simple table.
2.Create the new measure to calculate the percentage and hide one line.
Measure =
VAR categ = SELECTEDVALUE('Table test'[Category])
VAR da = CALCULATE(SUM('Table test'[Arrears]), ALLEXCEPT('Table test', 'Table test'[Category], 'Table test'[Date]))
VAR arrea = CALCULATE(SUM('Table test'[Arrears]), ALLEXCEPT('Table test', 'Table test'[Category]))
RETURN
IF(categ = "ab", BLANK(), DIVIDE(da, arrea)
)
3.Drag the field and measure into the line chart visual.
4.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Denismc ,
Based on my testing, please try the following methods:
1.Create the simple table.
2.Create the new measure to calculate the percentage and hide one line.
Measure =
VAR categ = SELECTEDVALUE('Table test'[Category])
VAR da = CALCULATE(SUM('Table test'[Arrears]), ALLEXCEPT('Table test', 'Table test'[Category], 'Table test'[Date]))
VAR arrea = CALCULATE(SUM('Table test'[Arrears]), ALLEXCEPT('Table test', 'Table test'[Category]))
RETURN
IF(categ = "ab", BLANK(), DIVIDE(da, arrea)
)
3.Drag the field and measure into the line chart visual.
4.The result is shown below.
Best Regards,
Wisdom Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for the responce, while that is a solution, ideally having a hide option on a chart would fix the issue on any element to be used. Have a great weekend.
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 |
---|---|
53 | |
27 | |
24 | |
14 | |
9 |
User | Count |
---|---|
76 | |
58 | |
47 | |
17 | |
12 |