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

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?