Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Dynamic Slicer query in Power BI

Hi, I have a table which has data in ‘000 INR. (Pls. refer ‘RawData’ Query). I would like to create a slicer in BI and give the user an option to slice data by the following: LC in '000 LC in Crs ...
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    7 years ago

    Hi Anonymous,

     

    I made one sample for your referecen. To create a measure as below.

     

    Measure = var sele = SELECTEDVALUE(EditedData[Select Currency])
var amount = SUM(RawData[Value])
return
IF(ISBLANK(sele),BLANK(),IF(sele="in US$ '000",amount/6,IF(sele="in US$ Mns",amount/100,IF(sele="LC in '000",amount,amount/3))))

     

    For more details, please check the pbix as attached.

     

    Regrads,

    Frank

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi all,

 

Could anyone pls. help me with the posted query?

 

Many thanks,

Deepak.