Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Show specific chart based on slicer, using a mesaure

I want to be able to use a measure to show only a specifc chart, in place, based on a measure, e.g. If SLICER value A is selected, it will show Chart 1, If SLICER value B is selected, it will show Chart 2, etc.

This will drastically reduce the number of pages I need to create in my PowerBI reports, as I can have all my charts in on one place.

I beg you to seriously consider this, as having 100 pages to show 100 charts is just madness and it is so easy to click Selection ==> Hide Chart in the Selection Pane, so if PowerBI could just do this, even for just one chart at a time, i.e. hide all charts, except chart selected in measure.

Here is my proof of concept:

Show 01 Stacked Bar Chart =
IF(
    SELECTEDVALUE(df_questionmeta[Category]) IN {
        "Category A",
        "Category C",
        "Category E",
    }, 1, 0)

Show 03 Clustered Bar Chart =
IF(
    SELECTEDVALUE(df_questionmeta[Category]) IN {
        "Category B",
        "Category D",
        "Category F",
    }, 1, 0)


And then have this linked to an fx slot for visibility in the Formatting Pane for each particular created chart.

Please consider this.

Status: New