Forum Discussion
Change line chart value based on Slicer
Hello I have a slicer called as filter with two values, gross_premium and net_premium.
I have a table with year,gross_premium and net_premium column. I created a line chart which summaries the gross_premium and net_premium based on year, but I want to filter the displayed line based on the filter selection.
Is there a way in which it can be done?
As you can see, I want to display just the gross_premium (blue line) by selecting that value from the slicer.
Any help would be appreciated! Thanks!
Hey,
unfortunately this is not as we might expect using Power BI,
this blog post from my fellow datanaut GilbertQ explains how to achieve this using an unrelated table a little DAX:
https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
Hopefully this is what you are looking for.
Regards,
Tom
2 Replies
- TomMartens
Super User
Hey,
unfortunately this is not as we might expect using Power BI,
this blog post from my fellow datanaut GilbertQ explains how to achieve this using an unrelated table a little DAX:
https://www.fourmoo.com/2017/11/21/power-bi-using-a-slicer-to-show-different-measures/
Hopefully this is what you are looking for.
Regards,
Tom
- pavithra12Regular Visitor
Thank you Tom! That was helpful!