Forum Discussion
Slicer Behavior on Tiles
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!
Community ChampionWrap 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.
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.