Forum Discussion
Filtering data when user clicks on bar chart
Hello All,
I have report where I am showing sales for each month in bar chart.
Now my requirement when user clicks on bar I need to show top 10 sales for that month.
Could any one please help how to do
Hi Anonymous ,
You may firstly try amitchandak method.
Or you could add a page-level tooltip , then create a visual with User and Value field and apply TopN filter on this visual. In my sample, I select Top 3 for test:
When you hover over the visual/ the YearMonth bar, the output will be:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous , Just create a visual with TOP 10(of what, say item) and use that in another visual or Drill through report
example using sales measure
TOP 10 item sales =
CALCULATE([Sales],TOPN(10,all(Item[Item]),[Sales],DESC),VALUES(Item[Item]))
Hi Anonymous ,
You may firstly try amitchandak method.
Or you could add a page-level tooltip , then create a visual with User and Value field and apply TopN filter on this visual. In my sample, I select Top 3 for test:
When you hover over the visual/ the YearMonth bar, the output will be:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
