Forum Discussion

saranyasaran's avatar
saranyasaran
Regular Visitor
9 years ago

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 ?

Need Help

4 Replies

  • PowerDAX's avatar
    PowerDAX
    Resolver III
    9 years ago

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

    • saranyasaran's avatar
      saranyasaran
      Regular Visitor
      9 years ago

      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.

      • PowerDAX's avatar
        PowerDAX
        Resolver III
        9 years ago

        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.