Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
saranyasaran
Regular Visitor

line chart on filter selection

in line chart is it possible to get lines according to multiple country selection, for now its showing only average but I want to display for multiple country. Eg. Initially one line per chart will be dispalyed and if we select 3 country from filter section, 3 lines should be displayed. how is this possible in power BI ?

4 REPLIES 4
Gonmsilva
New Member

I have the same doubt. Can somebody help on this?

PowerDAX
Resolver III
Resolver III

You should be able to simply add the country to the legend of the chart.

powerdax.com

Hi,

Thanks for the reply. If i the country to the legend of the chart we get multiple lines, is there any option to get an average line initially and get multiple line based on filter selection.

you could do something clever with the DAX like checking if the country field is filtered (i.e. IF( NOT( ISFILTERED( 'Table'[Country])), xxxxx) and pass an ALL( 'Table'[Country]) filter if it was not filtered.

powerdax.com

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.