Need to add measures and Hierarchy on Slice

[Anonymous]

Hello Team ,

I am very New in Power BI.

1.And i have requirment user can select measure from list and when user select measures from list then only particular measures will appears on MY reports .

2.I have hierarchy on my dimension and i need dimension has to be come in Slice or any other method .

Regard's

Ravi

[v-caliao-msft · Accepted solution]

@Anonymous,

1.And i have requirment user can select measure from list and when user select measures from list then only particular measures will appears on MY reports .

We can create a dynamic measure to achieve this requirement. Please refer to the steps below.

1. Sample data
   
2. Create a new table by enter data.
   
3. Create a measure on Sales table
   Measure = 
   var selecteditem = MAX(Slicer[Slicer])
   return if(selecteditem="Sales",MAX(Sales[Sales]),MAX(Sales[Sales])-MAX(Sales[Cost]))
4. Use this measure in your visual.
   

2.I have hierarchy on my dimension and i need dimension has to be come in Slice or any other method .

We can add a hierarchy level to slicer.

Regards,

Charlie Liao