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 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