Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hello,
I am using one graph (line chart) for the visualization of one value and I need to extend this visualization. I want to display the second value in the line chart. This is not a problem. The problem is that I need to display the same value, but only apply a different filter to it. Is there any way how to do it in one line chart? I do not want to have two line chart graphs. I want to see the difference in one graph.
Thank you for your help.
Jakub
Solved! Go to Solution.
Hi @jakub_vana
Are the two filters on the same column or on different columns? If it is on the same column, you can add that column to Legend field of the line chart. Then in Filter pane, filter the legend column to show only values you want to see.
Another solution is to create two measures and add filter expressions in the measures. For example,
Gross Sales France = CALCULATE(SUM(financials[Gross Sales]),financials[Country]="France")
Gross Sales Germany = CALCULATE(SUM(financials[Gross Sales]),financials[Country]="Germany")
Add both measures to Y-axis of the line chart.
If the two filters are on different columns, you can use the latter solution with measures.
Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
Thank you very much, it helps me a lot!
Hi @jakub_vana
Are the two filters on the same column or on different columns? If it is on the same column, you can add that column to Legend field of the line chart. Then in Filter pane, filter the legend column to show only values you want to see.
Another solution is to create two measures and add filter expressions in the measures. For example,
Gross Sales France = CALCULATE(SUM(financials[Gross Sales]),financials[Country]="France")
Gross Sales Germany = CALCULATE(SUM(financials[Gross Sales]),financials[Country]="Germany")
Add both measures to Y-axis of the line chart.
If the two filters are on different columns, you can use the latter solution with measures.
Hope this helps.
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.
User | Count |
---|---|
93 | |
85 | |
78 | |
68 | |
62 |
User | Count |
---|---|
113 | |
99 | |
96 | |
64 | |
58 |