Static amount of columns in a matrix (or dynamic changing of column width)

[jellyjoe]

Hello everyone,

I've ran into an issue when creating a visualisation.

I have a line chart that shows some data on a day by day basis, i also have a matrix that shows similiar data:

Here the days on the matrix and the days on the line chart are lined up.

The issue starts when i choose a month that has less than 31 days:

Here the days dont line up due to matrix being shorter and line chart still scaling to the given width.

Is there a workaround to this problem? Or maybe some custom visual combining matrix and line chart?

Thanks in advance.

[mahenkj2 · Accepted solution]

Hello @jellyjoe ,

Pls see below link:

https://community.powerbi.com/t5/Desktop/Chart-with-data-table/m-p/599120

I tried the custom visual at below link:

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA200000675?tab=Overview

I think it work as you intend. Visual rating is low, I am not sure why, but it looks to be working well, please check.

Hope it helps.

[jellyjoe]

Sorry for the late response, this visual does indeed work quite nicely however it doesn't have some functionalities necessary for me. I've managed to fix the issue by creating a dimension table with all 31 days and always displaying 31 days even wen the month is shorter. Nevertheless the visualisation could prove useful for someone looking for similiar solution so I'll mark it as it.

Thank you for support