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 b...
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
when you say you can't make it work, what do you mean exactly. have you put slicers on the page?