Forum Discussion
Slicer Behavior on Tiles
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!
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!
10 Replies
- dkay84_PowerBI
Microsoft Employee
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
Community Champion
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.
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.
