Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 ?
I have the same doubt. Can somebody help on this?
You should be able to simply add the country to the legend of the chart.
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.
User | Count |
---|---|
98 | |
90 | |
84 | |
71 | |
67 |
User | Count |
---|---|
114 | |
103 | |
100 | |
72 | |
64 |