Excuse me for my limited knowledge.
I have a large dataset built as follows (simplified):
and I have been able to transfer this into a new presentation that looks like this by adding custom columns for each month;
by using the folowing formula:
= Table.AddColumn(#"Added Custom", "Jan", each if [Start] < #date(2019,1,5) and [End] > #date(2019,1,25) then [Resources] else null)
This works as I hoped it will, and even looks pretty when I add "conditional formatting"to the result.
But I was also hoping to present this in a column chart like this:
I am able to do this in Power BI, but I dont have any customisation possibilities for the chart in the built-in visuals.
I have tried linking it to a date-range table (to use monthly as the axis), but as I understand this table can only be linked to start or end date, since the other columns only contains numbers.
Any suggestions what I sholud try next?
Go to Solution.
Based on my test, you could refer to below steps:
Unpivot all your month columns in query editor:
Import custom visual from market place and choose the Infographic designer:
Set below format:
You could also download the pbix file to have a view.
View solution in original post
Thank you! Unpivoting the months columns was the solution I was looking for. I have tested on the complete dataset and it is working.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.