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!

     

     

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
9 years ago

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.

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    9 years ago

    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.

    • Anonymous's avatar
      Anonymous
      Not applicable
      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 can't download your sample file. Have you resolved the issue? Do you mind share your sample data on the Onedrive.

        Thanks,
        Angelia