Forum Discussion
Slicer
@colourfullife
Yes, it is possible. Since you have a measure for each line in the graph, create a table using the Enter Data option on the Home ribbon. Enter All the measure names that you use in the charts. Insert a slicer and drop the measure names.
Modify each measure to check if the particular measure is selected in white, this way you can select what to display on the chart.
You can even select multiple measures.You can download the file : https://1drv.ms/u/s!AmoScH5srsIYgYYwi9h4WbIw8meNxw?e=cRbXdT
________________________
If my answer was helpful, please consider Accepting it as the solution to help other members find it
Click the Thumbs-Up icon if you like this🙂🙂
Fowmy i made a table using enter data in home tab.
after what do i need to do?
Anonymous
Modify each measure to include the condition to show the selected measure. Check my file and you will understand how it works.
I provided the steps in my original reply.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Fowmy yes, i thought i understood your steps and followed but the result doesn't come out like yours.
1. made a table
2. added highlighted dax part in my origianl dax to link.
did i miss something here?? if so please let me know.!
@colourfullife
Make sure you are typing the same value in the measure as in the Slicer Table "PO (CDD)", you have space at then like "PO (CDD) "
Hope you make a slicer and inserted the Slicer column there?
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂