Forum Discussion
Helper IData slicer to activate indicator
Hello friends, how are you?
I have a problem and I need to find out if it's possible.
I have a study that is done analyzing data from 2010 to 2021.
But the problem is that studies from 2010 to 2019 have a certain specific look to show for these pages, while the years 2020 and 2021 have some graphs that are different.
I have a slicer that filters the Year that the user wants to analyze. Is it possible to make it somehow, when selecting the years 2020 or 2021, to activate some indicator or make some specific graphs change?
Because the solution of buttons for activating the indicator did not like very much for the people who are analyzing the data.
3 Replies
- amitchandak
Super User
ErickReiis , You can use conditional formatting (only supported with one measure and no legend in visual)
You can have meausre like
Meausre =
var _cnt = countrows(filter(Table, Table[Year] in {2020, 2021}))
return
if(not(isblank(_cnt)), "Green", "Blue")
Learn Power BI Advance - PowerBI Abstract Thesis:
How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3
ErickReiisBut in that case, conditional formatting can only change the color of graphics right?
I would need the chart to somehow change (From a pie chart to a bar chart for example) when the person selects the years 2020 or 2021 in my Year filter.
Example: If person selects any year between 2010 to 2019, show pie chart.
If the person selects the year 2020 or 2021, change the pie chart to the bar chart.
v-jianboli-msftCommunity Support
Hi ErickReiis ,
Here is an document about how to show or hide Power BI visual by slicer selection.
Maybe you can use the method in the document, when you select year between 2010 to 2019, display the pie chart and hide the bar chart. When the year 2020 or 2021 is selected, swap their states.
Best Regards,
Jianbo Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
