Slicer Behavior on Tiles

[irnm8dn]

I would like to use a series of user selections with in 2 or 3 slicers, to output information in the Tile (Card format).

Is there a way to require user selections (as inputs) before exposing information in the tile?

Thanks!

[dkay84_PowerBI]

This blog post should show you how, although you will have to adapt it to the specifics of your data/use case:

https://blog.crossjoin.co.uk/2016/04/25/dynamic-chart-titles-in-power-bi/

[Greg_Deckler]

Wrap your measure with an IF ISFILTERED statement. Or perhaps even nested IF ISFILTERED statements:

https://msdn.microsoft.com/en-us/library/gg492163.aspx

Just return BLANK() if not filtered.

[irnm8dn]

@Greg_Deckler

Thanks, but as a newb I am not sure how to proceed.  Any more detail you can offer.  How to do this in the table?

[Greg_Deckler]

If you post sample data I can be more specific to your use case:

Measure = IF(ISFILTERED([Thing]),SUM([Column]),BLANK())

[Thing] is a column that I have a slicer on. SUM[Column] is what I am calculating for my measure to display with it is filtered. Returns BLANK if nothing is chosen in [Thing] slicer.

[irnm8dn]

Awesome.  I am close, but the display in the tile is a constant from a specific cell in a column.  Not a calc.  Any thoughts.  I am simply traying to show a display, based on a selection in the slicer.

[Greg_Deckler]

I need some sample data and example of what you are trying to display, otherwise I'm just shooting in the dark. Might be able to get there with something like a MAX(VALUES()) but I can't be sure without seeing an example.

[irnm8dn · Accepted solution]

@Greg_Deckler

Okay, please see the link to a dataset and .pbix file.  Thansk for your help, I am tied in knots on this one.  This is the jist of what I am trying to do:

https://www.dropbox.com/sh/wsy4w3zhtc3s088/AABzGd4YyT3TxmbX_kc7NrDga?dl=0

User selects a Product, Budget and Spend Level - outputs are shown on two tiles in the dashboard.

1.  Budget and Spend Level shown as currency (properly formatted)

2.  Spend Level of <10,000 to be shown as "Less Than $10,000" but should be formatted as a whole number (if possible).

3.  Tile identified as Cost-Per-Thousand should be shown as it appears in the table without a function.  i.e. Based on the selected Product, Budget and Spend Level the Cost-Per-Thousand is...

4.  Count of product based on calculation expressed in the .pbix file

Thanks for the help, it is greatly appreciated!

[v-huizhn-msft]

Hi @irnm8dn,

I can't download your sample file. Have you resolved the issue? Do you mind share your sample data on the Onedrive.

Thanks,
Angelia

[v-huizhn-msft]

Hi @irnm8dn,

I download the .pbix file, I saw the three slicer affect the card visual well. And I still confusing how calculate the CPM?

Best Regards,
Angelia

[irnm8dn]

@v-huizhn-msft

Algelia, thanks to @Greg_Deckler there was a .pbic file shared that showed the exact behavior I was trying to achive.  I have copued the DAX statement for the created measure, which requires the filters fo be selected, before results are shown in the tile.  I hope this helps, and @Greg_Deckler - Thanks.

measure =
IF (
HASONEFILTER ( 'Master Rate Data'[Product] )
&& HASONEFILTER ( 'Master Rate Data'[Budget] )
&& HASONEFILTER ( 'Master Rate Data'[Spend Level] ),
MAX ( 'Master Rate Data'[Column] )
)

That aside, CPM is an abbreviation for cost-per-thousand.  So the equation is:

Cost (Budget) / Total Units * 1,000