Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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...
  • shafiz_p's avatar
    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