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
Orstenpowers
Post Patron
Post Patron

Line and bar graph; bar graph is okay, but line graph is showing one line only

Dear all,

I hope you can help me...

Below you do see my table and the related graph.

The bar chart, indicating the cumulated amount, is correct.

Unfortunately the line graph is not, as it shows the values of the column highlighted in yellow. However, I would have expected two lines illustrating the values of the column highlighted with blue.

In the end, this visual should show

two lines, comparing the results by month (incomlete)

two bars, comparing the cumulated results by month (completed)

 

PBI_Graph.JPG

Anybody here who could help me?

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@Orstenpowers , As of now power bi does not split line based on legend in this visual.

 

Check for custom visual or log and Idea.

 

Or create measure for this year and last year

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

 

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@Orstenpowers , As of now power bi does not split line based on legend in this visual.

 

Check for custom visual or log and Idea.

 

Or create measure for this year and last year

Power BI — Year on Year with or Without Time Intelligence
https://medium.com/@amitchandak.1978/power-bi-ytd-questions-time-intelligence-1-5-e3174b39f38a
https://www.youtube.com/watch?v=km41KfM_0uA

 

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.