Forum Discussion

erhan_79's avatar
erhan_79
Icon for Post Prodigy rankPost Prodigy
5 years ago
Solved

measure filter slicer

Hi there ;

 

in attached pbix i created a calculaed measure which is calling status .It gives the order number statu "Close" or "Open" , i wan to filter with filter slicer open and close orders on the table but because of to be measure i can not filter statu measure.

 

Also i want to create a stacked column chart and want to show quantities about closed orders and open orders etc. 

 

How can i manage them could you help pls ? 

 

thank in advance , you can find shared already pbix file below 

 

 

  • Hi erhan_79 

     

    Using measures as filter lead is not really working. Did you try to calulcate the status in a calulcated column. Calulcated columns are better to be used as filters as well as in visuals as cluster criteria and bring more usability from my experience. 

     

    Best regards

    Mikelytics

    ------------------------------------------------------------------------------------------------------------------------------

     

    Did I solve your request?. Please mark my post as solution.

     

    Appreciate your Kudos.

2 Replies

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar

    Hi erhan_79 

     

    Using measures as filter lead is not really working. Did you try to calulcate the status in a calulcated column. Calulcated columns are better to be used as filters as well as in visuals as cluster criteria and bring more usability from my experience. 

     

    Best regards

    Mikelytics

    ------------------------------------------------------------------------------------------------------------------------------

     

    Did I solve your request?. Please mark my post as solution.

     

    Appreciate your Kudos.

  • mwegener's avatar
    mwegener
    Icon for Most Valuable Professional rankMost Valuable Professional

    Hi erhan_79 ,

     

    so that you can filter by status, it must be a calculated column and not a measure.