Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

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 info...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    9 years ago

    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's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Hi Anonymous,

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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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