Forum Discussion

AartiD's avatar
AartiD
Icon for Helper II rankHelper II
1 year ago
Solved

how to convert Measure into Slicer

I want to convert one measye "Sales Type Indicator " Into Slicer. and used below steps , but its not working. Note:- Monthly Avg. SKU No., Current Month Sales and Sales type Indicator all are measure...
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi AartiD ,

    Thank you for sharing your scenario. I have reproduced the requirement using sample data and can confirm that everything is functioning as expected

    1. The  Sales Type Indicator  measure is categorizing the SKUs correctly.

    2. The disconnected slicer is filtering the visuals based on the user's selection.

    3. No calculated columns were required as everything is managed through DAX measures.

    FYI:

     

     

     

    I have attached a PBIX file with the complete setup for your reference. Please let me know if you would like a walkthrough or any further adjustments.

     

    Best regards,
    Yugandhar.

V-yubandi-msft's avatar
V-yubandi-msft
Icon for Community Support rankCommunity Support
1 year ago

Hi AartiD ,

Thank you for sharing your scenario. I have reproduced the requirement using sample data and can confirm that everything is functioning as expected

1. The  Sales Type Indicator  measure is categorizing the SKUs correctly.

2. The disconnected slicer is filtering the visuals based on the user's selection.

3. No calculated columns were required as everything is managed through DAX measures.

FYI:

 

 

 

I have attached a PBIX file with the complete setup for your reference. Please let me know if you would like a walkthrough or any further adjustments.

 

Best regards,
Yugandhar.

  • AartiD's avatar
    AartiD
    Icon for Helper II rankHelper II
    1 year ago

    Superb, this is perfect and working. thank you so much.