Forum Discussion

Kyle1's avatar
Kyle1
Regular Visitor
8 years ago
Solved

Filtering Line Charts

Say if I have a sample data set Category Bridge Value A Bridge 1 2 B Bridge 1 3 C Bridge 2 7 B Bridge D 1 4 C Bridge D 2 8 B Bridge D 2 8 C Bridge 1 9 A B...
Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    Kyle1,

    Create a disconnected table as show in attached PBIX file.

    Regards,
    Lydia

kohlivinayak's avatar
kohlivinayak
Resolver I
8 years ago

Hi Kyle1

 

I am not sure exactly what issue you are facing, but according to the requirement you need to create a measure not a column in this case.

 

Second, we can add measure to a line chart.

 

And you are trying to plot these values against which column on the x-axis ??

 

Thanks

Vinayak

  • Kyle1's avatar
    Kyle1
    Regular Visitor
    8 years ago

    Hi kohlivinayak,

     

    Thanks for the reply. I wasn't aware that you can place more than one measure on a line chart. I would want the first measure to be named "2016 Q4" and the 2nd measure to be named "2017 Q1" on the x axis. These categorizations are not included in my dataset.