Slicer based on all the column name not effecting the line charts

[aakash_086]

My Data is like 

Month	sk6	sk7	sk8	sk9
30/04/2018	60	10	64	8
31/05/2018	12	16	48	9
30/06/2018	26	85	51	54
31/07/2018	83	17	11	72
31/08/2018	6	19	97	19

when puting up a line chart (each for all the columns) I am not able to use the sk6,sk7,sk8,sk9 (i.e column names) as slicer so as to select/unselect the line only of that particular column

[Idrissshatila · Accepted solution]

Hello @aakash_086 ,

you need to unpivot the sk columns so that you can use them in a slicer.

check this to learn more about this concept https://youtu.be/URAJ_aDiREE?si=9VqVRrkVECxnHjmF

[ezequielalmeida]

Hello @aakash_086, assumming that you have good reasons for not wanting to unpivot those columns, seems to me that what you're trying to do can be solved using Field Parameters - https://learn.microsoft.com/en-us/power-bi/create-reports/power-bi-field-parameters

You would need to create an explicit measure for each field's sum, and then create a field parameter containing said measures. Then you can add the parameter to the Y axis in the visual and can also add a slicer with the same parameter, achieving the behaviour you're looking for. 

Here's an example.

Hope this helps, let me know anyways.

[aakash_086]

Hi @ezequielalmeida : Thanks for the suggestion , I tried it and it works great. Thanks for help !!

[Idrissshatila · Accepted solution]

Hello @aakash_086 ,

you need to unpivot the sk columns so that you can use them in a slicer.

check this to learn more about this concept https://youtu.be/URAJ_aDiREE?si=9VqVRrkVECxnHjmF

[aakash_086]

Hi @Idrissshatila : Thanks for suggesting the solution , but unpivoting it makes new column and value and the original columns disappear, I want to use the columns for individual line charts and then use slicers to select/unslect line graphs for any of the sk values.

[mahenkj2 · Accepted solution]

Hi @aakash_086 

as @Idrissshatila suggested, unpivoting is a preferred approach, see created file here:

https://drive.google.com/file/d/16jVt8M7V-jnoWfQHIzVHPjVU9D4MRlYy/view?usp=sharing

Hope it helps.

[aakash_086]

Hi @mahenkj2 : Thanks for the solution , certainly the easiest approach approach to achieve it.

[Ashish_Mathur]

Hi,

Why would Idrissshatila's suggestion not work for you.

[aakash_086]

Hi @Ashish_Mathur : I tried with Idrissshatila's suggestion but I was not approaching it correctly, perhaps after unpivoting we can use the unpivoted columns and no need for pivited columns anymore to plot it. Thanks !!