Line graph slicer

[miro231180]

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

[v-csrikanth]

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.

[v-csrikanth]

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.

[v-csrikanth]

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.

[Ashish_Mathur]

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.

[miro231180]

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 

[miro231180]

what do you meam? 

[Deku]

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

[miro231180]

 Something wrong in the filter 

[Deku]

Are the implict, or explicit measures?

[miro231180]

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? 

[Deku]

[Deku]

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