Forum Discussion
Dynamic TopN with Other Sort Issue
I have a data set of inspections and was able to create a Top 20 measure to include the Top 20 and lump the remainder into an "Other" category. My issues is I sort the data and the "Other" categ...
Sorry for the delay in my response. I am swamped with work. Ugh.
It is very similar to your blog. I downloaded your pbix file and played with it but it does not quite work for what I need. I need to display the results in a bar chart. When I change your table in the sample data to a bar chart it does not work the same. You lose the "Others". It does not let me use the Measure Country in the Axis for the bar chart.
Anonymous,
Could you please share sample data of your table here? I will test it in my Desktop.
Regards,
Lydia
I am not sure how to share a file here so I have to show a picture.
Anonymous,
You can upload the file to OneDrive and post shared link of the file here.
Regards,
Lydia