Forum Discussion

sylwestercz's avatar
sylwestercz
Helper I
10 years ago

Slicer with measures ?

Hello All,   I hope you can help a newbie. I recently started using PowerBI Desktop and I am in the process of building my first dashboard for the Revenues (excited! :smileyvery-happy:). I will try...
Need Help
Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hi,

 

You could take this approach.

 

Create a table called Measures. The contents will be 

MeasureName , MeasureID as column names

The rows will be

Gross Revenue , 1

Net Revenue , 2

 

Create a measure in the data model as follows :

 

Showvalue=switch (TRUE,
Min ( Measures[MeasureID] ) = 1,
( [SalesQty]  ),                            /* replace this by your fomula for Gross Revenue or if already exists put that measurename */
Min ( Measures[MeasureID] ) = 2,
( [Sales] ) )                              /* replace this by your fomula for Net Revenue or if already exists put that measurename */

 

 

Now create a slicer with Measure table column MeasureName .

 

In the chart or table , use the measure Showvalue as your values column to chart or display in table.

 

and you will have the results.

 

Best

 

Cheenusing

  • padodge's avatar
    padodge
    New Member
    9 years ago

    I have tried several variations of this approach with MeasureID being in one table and SalesQty being in an unrelated table (within a Tabular model).  The calculated column (measure) does not fail, but the slicer on MeasureID has no affect in Power BI.  Am I missing something?  Is it possible to slice a value from an unrelated table?

    • GayatriCH's avatar
      GayatriCH
      New Member
      9 years ago

      Hi,  

       

      I am also having an issue with slicer pointing to calcualted measure. Is there a way to create a slicer in power bi that points to calculated measure? 

       

      Thanks,

      Gayatri

  • Highlander's avatar
    Highlander
    Frequent Visitor
    9 years ago

    Really helpful, works brilliantly thank you so much!

    I'll look out for your other solutions.

    Excellent effort!

  • Highlander's avatar
    Highlander
    Frequent Visitor
    9 years ago

    Many thanks for this excellent solution, really works so well - had seen this type of example before, but this works brilliantly..the penny has dropped!  

    Thanks for posting this

    Kind regards

    Highlander

    • Highlander's avatar
      Highlander
      Frequent Visitor
      9 years ago

      So good it deserved  2 posts.

      (new to this community!_)

  • sure19's avatar
    sure19
    Helper II
    9 years ago

    hi Mr. Cheenusing,

     

    i have an excel sheet with few columns like

    Date, Name, State, Total Sales (numbers), M&S(Num), Elect(Num), Water(Num), Fuel(Num), etc.

     

    i am not able to use slicer for M&S, Total Sales, Elec, Water, Fuel? how can i use this in the visualisation as slicer?