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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.