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
cbrunsynergy
Frequent Visitor

Issue with Aligning a Matrix and Histogram for Monthly Variation Rates in Power BI

Hello Power BI Community,

I am facing a challenge with my Power BI report and would appreciate any guidance you can provide. I have created a histogram to display monthly data, and below it, I've added a matrix to show the rate of change compared to the same month in the previous year. The histogram visual does not inherently support displaying the variation measure in the way I need, so I've cleverly masked columns in the matrix to only display the values beneath the histogram bars (as seen in the attached image).

The issue arises when I select a different year that contains a mix of positive and negative variation rates. The positive values cause a misalignment as they take up more space, and thus the matrix's width no longer matches the histogram above it. This disrupts the visual coherence of the report.

I am looking for a solution to ensure that the matrix aligns perfectly with the histogram regardless of the variation rates being positive or negative. Has anyone encountered a similar problem, or could you suggest a way to keep the visual elements aligned consistently?

Thank you in advance for your help!

cbrunsynergy_1-1705056405031.png

 

1 REPLY 1
lbendlin
Super User
Super User

That's not a histogram  (a histogram is sorted by value).

 

Consider using a custom visual like Deneb that can overlay marks while using the same X axis.

 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).

Do not include sensitive information or anything not related to the issue or question.

If you are unsure how to upload data please refer to https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

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.