Forum Discussion

daytonwinter's avatar
daytonwinter
New Member
1 month ago
Solved

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...
Need Help
  • Olufemi7's avatar
    Olufemi7
    1 month ago

    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 

v-abhinavmu's avatar
v-abhinavmu
Community Support
1 month ago

Hi 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.