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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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

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

 

@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 

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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