Forum Discussion
Slicer Behavior on Tiles
- Anonymous9 years ago
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!
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/