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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
smileyours_1
New Member

Combination line chart - Budget and Result. Result should only show months with result

I have what i am sure a very simple problem and im sure that is why i cant find the solution posted anywhere since its too simple 😁

 

I want to create a combined line chart with result and budget for 2022. As it is now I only have results for January so I only want that line to display the result for January. The Budget line should show all 12 months. 

 

As it is now the Result line shows the result for January on all 12 months. The Budget line shows correct results. (Se image)

Skärmbild 2022-02-16 090355.png

 

 

 

 

I have Results in one table and Budget in another table. Both tables have dates formated in the same way. 

 

How can I solve this?

2 REPLIES 2
smileyours_1
New Member

I have that now. It doesnt change anything though. I used this https://forum.enterprisedna.co/t/extended-date-table-power-query-m-function/6390

 

I will try and use the tips in this post to get the results i need. I hope I succeed 

amitchandak
Super User
Super User

@smileyours_1 , Are you using a common date table ?

if not cosider common date table adn use that on axis

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.