Forum Discussion
Filter in Linechart
- 1 year ago
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
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