Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I need to compare few values on line chart for multiple selction from slicer. The below is a sample data on which i am working:
Territory | Date | Target | Actual | Deviation |
North | 1/30/2020 | 5000 | 8000 | 3000 |
South | 2/30/2020 | 5500 | 7000 | 1500 |
West | 3/30/2020 | 6000 | 5000 | 1000 |
East | 4/30/2020 | 6500 | 6000 | 500 |
North-West | 5/30/2020 | 7000 | 4500 | 2500 |
I am showing Target, Actual and Deviation values on line chart and usig Territory as a slicer.
I want multiple lines for each territory selected in the slicer but it shows only single line (for each Target, Sales and Deviation) when selecting multiple values in the slicer. This is needed when i want to compare Target, Sales and Deviation values for 2 or more territories on the line chart.
I needed help from the experts to achieve the same.
Thanks
I
Hi @jitpbi ,
Like this?
Compare multiple territory values?
You can select those three columns and unpivot them.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jitpbi ,
Has your problem solved?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jitpbi , Inline visual. You can either have multiple measure or legend (Territory) not both together
Hi @amitchandak, @Greg_Deckler
I am not using legend only using values. I want to have multiple values when selecting 2 or more territories from the slicer visual to compare them on line chart.
Thanks
@jitpbi - Right, you could use Territories in your Legend and a single Value but then you would need three of these charts for your three different measures. There isn't a way to get what you want really in a single line chart. You may have to pick a different visualization.
Thanks @Greg_Deckler , Can you please suggest any such visualization where i can compare my values for multiple territories.
@jitpbi - Try a bubble chart maybe. Attached PBIX below sig.
Sure @jitpbi - Hopefully that works for you.
@jitpbi - Well, this is correct, once you have multiple Values, you cannot add Territory to your Legend. You could add Territory to your Axis so you can drill down into it maybe. Or add a slicer for Territory perhaps.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |