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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Lucas_Phil
Helper I
Helper I

Combo Chart: Line values only shows when column values are not blank

Hi everyone!

I have a situation here with the combo chart: I want to related two measures, but the line values only shows when the columns values are not blank.

In the image the table shows that at 12-05 I have 3 actions, but as I don't have any complaints, it doesn't shows the line values.

Lucas_Phil_0-1668081799760.png

Lucas_Phil_2-1668081969946.png

 


If I choose to show itens with no data for the date in x axis, I have this: 


Do you know if I have another option here? "Show itens with no data" is not something I want, because I need to add some filters to the graph, otherwise would be too much info that don't need to be there. And the dots get connected. 


If I change the x axis to "week", I have what would be the perfect scenario, but per week and not for the exactly date. The perfect scenario includes the dots not being connected, just the dots.

Lucas_Phil_0-1668082793205.png

To clarify possible doubts: the two measures are in separated tables, but both have a data table connecting their date column.
I didn't upload a sample of the file because looks to me that is more as something possible or not possible to do.. But if you think it helps, I can make one and post it here 🙂 

Thank you in advance!!

1 ACCEPTED SOLUTION

Hi, @Lucas_Phil 

 

You can try the following methods. Use Line and stacked column chart views.

vzhangti_0-1670393052396.png

Modify the range of 2 Y-axes.

vzhangti_4-1670393281822.pngvzhangti_2-1670393093157.png

Result:

vzhangti_3-1670393254947.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

 

View solution in original post

4 REPLIES 4
v-zhangti
Community Support
Community Support

Hi, @Lucas_Phil 

 

Listening to your description should be achievable. Can you provide easy data for testing? The output you expect can also be shown in pictures or excel.

 

Best Regards,

Community Support Team _Charlotte

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

Hi @v-zhangti !!
Sorry to bother you, but did you have time to take a look on this?

I tried some importaded visuals, but none until now satisfied with the exact same result I'm expecting. 
Thank you!

Hi, @v-zhangti !

Thanks for your reply.

The expected output should be something like this. 

Lucas_Phil_0-1668165025713.png

The data sample:
https://docs.google.com/spreadsheets/d/1remOWfAXZ6UrX64EZlOxQdxkcjc1YUoY/edit?usp=sharing&ouid=10939...


Thank you again!

Hi, @Lucas_Phil 

 

You can try the following methods. Use Line and stacked column chart views.

vzhangti_0-1670393052396.png

Modify the range of 2 Y-axes.

vzhangti_4-1670393281822.pngvzhangti_2-1670393093157.png

Result:

vzhangti_3-1670393254947.png

Is this the result you expect?

 

Best Regards,

Community Support Team _Charlotte

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

 

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.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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