Filter a chart based on a measure within a "card"

[heidibb]

Hello,

Wondering if this is possible.

I have a dashboard with 8 "cards" showing 8 different measures for the dimensions selected in the slicers.

My wish is that I can click on one of these "cards" and have a clustered column chart populate with that particular measure.

For example:

Cards might include # customers, $ sales and Avg $ per Customer across the top of my page.

If I click on # customer card, the bar chart would show the # of customers by sales person

If I then click on the $ sales card, the same bar chart would then show the $ sales by sales person

If I then click on the Avg $ per Customer card, the same bar chart would then show that measure by sales person.

Possible?

Thanks so much.

[v-haibl-msft · Accepted solution]

@heidibb

I agree with @Habib, we can use Chiclet Slicer to simulate the “Cards”. A new table which includes the measure names needs to be created.

Then create a measure with following formula.

MeasureSelected = 
IF (
    HASONEVALUE ( Table2[Measures] ),
    SWITCH (
        FIRSTNONBLANK ( Table2[Measures], Table2[Measures] ),
        "# customers", [# customers],
        "$ sales", [$ sales],
        "Avg $ per Customer", [Avg $ per Customer]
    ),
    BLANK ()
)

Drag Table2[Measures] column into Category of Chiclet Slicer and MeasureSelected into Value of Clustered column chart.

Best Regards,

Herbert

[heidibb]

Thanks both! Not my ideal solution as it adds another component to the view that I was hoping to eliminate, but it might work. One question. I just downloaded the newest version of Power BI and I don't have the chiclet slicer option. Is that a seperate add-in that needs to be downloaded seperatly?

[heidibb]

I was able to get the chiclet slicer just fine! Now I'm following your example and I've created a new datasource with hand typed terms for my measures. I'm just not sure how to link this up to my actual data. I'm not clearly understanding what the calculation is doing.

Thanks in advance!!

[heidibb]

Sorry for the many follow-up posts, but I was able to get this to work for me! I didn't pay close attention to your attached picture, so now I understand that the new meausure needed to be created in the main data set! Works fine! Thanks so much for your help!

[Habib]

Hi @heidibb

Card visual can't be used as selector and you will not be able to filter your other visuals based on its selection.

You need to look for some other workarround where you can apply a filter which will be displayed as tiles on dashboard top and you need to create your measures based on some DAX by applying SWITCH statement. Below artical can help you regarding this although its about Power Pivot.

http://sqljason.com/2012/11/measure-selection-using-slicers-in.html