Filter the line chart visual

[Preeti_Yadav]

Hi,

The requirement of the POC i am doing is that , wants to view the bookings of the products by Continent and Category by revenue on Line chart. However,  don’t want two separate visual for the same.Want to implement view of the attributes bookings on one go.

Needs to implement a solution where after selecting category on filter the line chart visual reflects the bookings of respective category.

Thanks !

[SanketBhagwat · Accepted solution]

Hi @Preeti_Yadav .

You can use the concept of Dynamic Axis in order to get the desired output.

You have to Unpivot your data and that will give you 2 columns named 'attribute' and 'value'.

Use the 'value' column in your visual and add 'attribute' into your slicer.

Regards,

Sanket Bhagwat.