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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Fidzi8
Helper IV
Helper IV

Line chart

Hi,
i need create this chart.

This chart is from my old report where I created secondary table but when I edit data - I must edit secondary table.
old.png

 

Now I create now report where I would like create new chart where I won´t have to have any secondary table.

new.png

 

- chart legend is "YES" and Type of loading

 

Thank you
Ondřej

8 REPLIES 8
amitchandak
Super User
Super User

@Fidzi8 , What is the challenge here. not able to get the real problem

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak, i don´t know how I insert two conditions (On-time? and Type of loading) into a chart.

 

Thank you
Ondřej

 

@Fidzi8 , you can not have two legends. nor two measures and legends. 

 

So append these two and create one column and try

 

New Type = [Ontime] & " " & [Type]

 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

@amitchandak, i create new column and I know why month sum ins´t 100%?

new1.png

 

Thank you 
Ondřej

Hi @Fidzi8 ,

 

Please share the sample data as well. We will understand your situations more clearly.

 

Best Regards,
Xue Ding
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-xuding-msft,
I need month sum 100%. Now is period sum 100%.

 

Best Regards,
Ondřej

Hi,
@v-xuding-msft@, @amitchandak  I don´t know how I have to edit chart.

Now my chart shows sum all months as 100% but I need sum one moth as 100%.

 


one month.pngall month.png

 

Thank you

Ondřej

@Fidzi8 , can you share the calculation /measure 

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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