Forum Discussion
Filter in Linechart
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
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
4 Replies
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 slicerHi 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 Hafizwhen you say you can't make it work, what do you mean exactly. have you put slicers on the page?
Hi Anonymous
Can you share the raw data screenshot???
it seems unclear to me..go to table view and sahre the screenshot..
