Forum Discussion
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
Resident 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
Most Valuable Professional