Forum Discussion
pavithra12
7 years agoRegular Visitor
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 gr...
- 7 years ago
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
TomMartens
Super User
7 years agoHey,
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
pavithra12
7 years agoRegular Visitor
Thank you Tom! That was helpful!