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 ,

 

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!