Forum Discussion

nadeemrajabali's avatar
nadeemrajabali
Helper I
4 years ago
Solved

Dropdown List for Slicer using Column and Measure

Hi All, I have a measure that calculate Total Cost of products. The measure is working fine if Financial Year, Brand or any other context is selected. I am new to Power Bi therefore struggling to cr...
Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    4 years ago

    Hi  nadeemrajabali ,

     

    Sorry for misunderstanding.

    Create a calculated column as below:

    Merged = 'data'[Brand Name]&"|"&'data'[Item Name]&"|"&"$"&'data'[Total Cost]

    Put "Merged" in the field of a slicer and you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

  • nadeemrajabali's avatar
    nadeemrajabali
    4 years ago

    Awesome, thanks Kelly highly appreciated

v-kelly-msft's avatar
v-kelly-msft
Community Support
4 years ago

Hi nadeemrajabali ,

 

Yes,click the dropdown button on the right upper corner of slicer to change the slicer type>choose: dropdown:

And you will see:

 

 

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!

 

 

nadeemrajabali's avatar
nadeemrajabali
Helper I
4 years ago

Hi v-kelly-msft ,

Thanks for your help again. But this is not I want in my drop list. I want my list as merged of three columns kind of a dynamic list. The reason I want it like this to have my list sorted as per ranking. In your drop down list. It's sorted by item # also the $ value is not the list.

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    4 years ago

    Hi  nadeemrajabali ,

     

    Sorry for misunderstanding.

    Create a calculated column as below:

    Merged = 'data'[Brand Name]&"|"&'data'[Item Name]&"|"&"$"&'data'[Total Cost]

    Put "Merged" in the field of a slicer and you will see:

    For the related .pbix file,pls see attached.

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!

  • nadeemrajabali's avatar
    nadeemrajabali
    Helper I
    4 years ago

    Awesome, thanks Kelly highly appreciated

  • v-kelly-msft's avatar
    v-kelly-msft
    Community Support
    4 years ago

    Hi  nadeemrajabali ,

     

    Glad to help.🙂

     

    Best Regards,
    Kelly

    Did I answer your question? Mark my reply as a solution!