Filter in Linechart

[Anonymous]

Hi everyone, I'm stuck on a seemingly simple problem. I have a linechart that i want to use filters on, my data looks like this (very simplified)

and the chart looks like this. Now i want to be able to filter by tax applied (Yes/No) and Discount Given (Yes/No), but cant make it work. How would you go about this?

 Many Thanks

[shafiz_p · Accepted solution]

Hi @Anonymous  To acheive this , first you need to convert your data table to the below format. See image:

Follow the below steps to achieve such transformation:

Import data table to below format:

Select first column and transform table :

Promoted as header first row.
Then select red marking column and unpivot other columns. See image:

Now you will get your desired result.

Close and load and define your desired visuals. See image:

After applying filter:

Hope this helps!!

If this solved your problem, please accept it as a solution and a kudos!!

Best Regards,
Shahariar Hafiz

[anmolmalviya05]

Hi @Anonymous, 

Your data structure currently has "Tax applied" and "Discount given" as separate rows. To use them as filters, they need to be part of the same row for each day and product category. Restructure the data like this:

Day Product Value Tax Applied Discount Given

Monday

Apples

10

Yes

No

Monday

Bananas

4

No

Yes

Monday

Carrots

9

Yes

No

Tuesday

Apples

12

Yes

No

Tuesday

Bananas

7

No

Yes

Tuesday

Carrots

15

Yes

No

Friday

Apples

9

Yes

No

Friday

Bananas

15

No

Yes

Friday

Carrots

13

Yes

No

To achieve this, you can use pivot/unpivot option available in Power Query editor.

Once the data is in column format, you can use them in a slicer

[Uzi2019]

Hi @Anonymous 

Can you share the raw data screenshot???
it seems unclear to me..

go to table view and sahre the screenshot..

[vanessafvg]

when you say you can't make it work, what do you  mean exactly.  have you put slicers on the page?