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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Syndicate_Admin
Administrator
Administrator

Problems with a Value in Comparative Chart

Have a good day community, I come asking for your help with the following:

I try to make a comparison of history vs current through a bar graph, at the moment we are using a chart from the store called "Horizontal Bullet Chart Whit Label"; The main idea of the graph is that we can see the current values above the historical ones, as shown in the image.

Chentefx_0-1727111326209.png

My problem is that in the current values the value is repeated in all the fields instead of being separated as in the historical one, how could I do it?

The historical information is a separate table unrelated to those of the current values, when I make a relationship between the tables the value that shows me in the historical changes me to the current values. that is, it didn't work for me.

1 ACCEPTED SOLUTION

Hello good day, thank you for your prompt response, I have managed to solve the inconvenience that was presented to me.

The solution, to review the tables and verify the relationships between them so that the segmentation of the values would be applied to me.

View solution in original post

2 REPLIES 2
Ritaf1983
Super User
Super User

Hi @Syndicate_Admin 

Can you please share a pbix or some dummy data that keep the raw data structure with expected results? It should help us clarify your scenario and test to coding formula.

How to Get Your Question Answered Quickly 

Regards,
Rita Fainshtein | Microsoft MVP
https://www.linkedin.com/in/rita-fainshtein/
Blog : https://www.madeiradata.com/profile/ritaf/profile

Hello good day, thank you for your prompt response, I have managed to solve the inconvenience that was presented to me.

The solution, to review the tables and verify the relationships between them so that the segmentation of the values would be applied to me.

Helpful resources

Announcements
July PBI25 Carousel

Power BI Monthly Update - July 2025

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

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 community update carousel

Fabric Community Update - June 2025

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