Forum Discussion
Line graph slicer
I am trying to make a line graph showing the progress of service through time. I have 3 measures of the service through that period of time, each one is presented through a number per month. When i place the table, it showes the number by (Sum). I am not able to make a slicer to show each measure by itself.
I would like to filter the graph by X, Y and Z as a catagory not by the numbers.
| Month | X | Y | Z |
| 23-Nov | 1 | 5 | 5 |
| 23-Dec | 5 | 6 | 2 |
| 23-Jan | 3 | 7 | 6 |
| 23-Feb | 2 | 8 | 4 |
| 23-Mar | 6 | 1 | 3 |
| 23-Apr | 2 | 5 | 6 |
| 23-May | 5 | 2 | 1 |
| 23-Jun | 2 | 4 | 8 |
| 23-Jul | 6 | 6 | 9 |
| 23-Aug | 7 | 2 | 1 |
| 23-Sep | 1 | 9 | 5 |
12 Replies
You can do this with field parameter.
- Go to modelling in the ribbon and select parameters then field parameter
- Add the 3 measures
- This will create a new table and a slicer on the page
- Replace the 3 measures in the table/matrix with the column from the field parameter
- You can then select which of those 3 measures are visable
I have tried that several times, it is not working.
Is there something I miss, the data in the table, the relation between the two tables after changing the Y axis by the parameter?
Something wrong in the filter
Are the implict, or explicit measures?
what do you meam?
Implict measures are where you drag a column on to a visual and select a aggregation type
Explicit is where you create a named measure by writing a DAX function
Field parameters can't use implicit measures
Hi,
In Power Query, right click on the first column and select "Unpivot Other Columns". Rename attribute to Category. Click on Close and Apply.
Hope this helps.
I would like to thank both of you. The only way it worked when I mixed both solution together, I made the unpivote colume, and change implecite number.
Thank you
Hi miro231180
Thank you for being part of the Microsoft Fabric Community.
As highlighted by Ashish_Mathur Deku , the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved?
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.
Looking forward to your reply!
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.Hi miro231180
It's been a while since I heard back from you and I wanted to follow up. Have you had a chance to try the solutions that have been offered?
If the issue has been resolved, can you mark the post as resolved? If you're still experiencing challenges, please feel free to let us know and we'll be happy to continue to help!
Looking forward to your reply!
Best Regards,
Community Support Team _ C Srikanth.Hi miro231180
We haven't heard from you since last response and just wanted to check whether the solution provided has worked for you. If yes, please Accept as Solution to help others benefit in the community.
Thank you.If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
