Forum Discussion
Limit Columns Shown in Column Chart
Hey all, I have the above pareto chart that I would like to clean up a bit. I am looking for a way to reduce teh number of columns that appear to make the visual easier to digest. The problem I run into is that the line is calculated based of the column. I can add a top N filter, but then that changes teh calculation for the line. Is there a way to limit the number of visible columns or hide some without affecting the calculated visuals?
Hello daytonwinter,
I tried something similar a while ago and ran into the same issue. Applying a Top N filter changed the Pareto line as well, not just the columns.
It really depends on how the Pareto line is built. I have used an approach where one measure controls which columns are displayed, while the cumulative percentage measure uses ALLSELECTED(). That lets the line continue to use all of the selected categories instead of only the visible columns.
Could you post the DAX for your cumulative percentage measure? That will make it easier to see whether the same approach will work for your model.
Microsoft Learn: ALLSELECTED
4 Replies
Hello daytonwinter,
I tried something similar a while ago and ran into the same issue. Applying a Top N filter changed the Pareto line as well, not just the columns.
It really depends on how the Pareto line is built. I have used an approach where one measure controls which columns are displayed, while the cumulative percentage measure uses ALLSELECTED(). That lets the line continue to use all of the selected categories instead of only the visible columns.
Could you post the DAX for your cumulative percentage measure? That will make it easier to see whether the same approach will work for your model.
Microsoft Learn: ALLSELECTEDHi daytonwinter,
Thank you for posting your query in the Microsoft Fabric Community Forum, and thanks to Olufemi7 & Abdubhai124 for sharing valuable insights.
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you for being part of the Microsoft Fabric Community.
Hi daytonwinter,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you
