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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
jitpbi
Post Patron
Post Patron

Multiple values on line chart with multiple selection on slicer

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:

 

TerritoryDateTargetActualDeviation
North1/30/2020500080003000
South2/30/2020550070001500
West3/30/2020600050001000
East4/30/202065006000500
North-West5/30/2020700045002500

 

I am showing Target, Actual and Deviation values on line chart and usig Territory as a slicer. 

 

jitpbi_0-1597925131844.png

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

11 REPLIES 11
v-lionel-msft
Community Support
Community Support

Hi @jitpbi ,

 

Like this? 

Compare multiple territory values?

Capture.PNG

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.

Hi @v-lionel-msft ,

 

No, it is still there. Any suggestion to do that.

 

Thanks.

amitchandak
Super User
Super User

@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.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

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.

Greg_Deckler_0-1597931238701.png

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Thanks @Greg_Deckler 

Sure @jitpbi - Hopefully that works for you.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...
Greg_Deckler
Super User
Super User

@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. 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
Mastering Power BI 2nd Edition

DAX is easy, CALCULATE makes DAX hard...

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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