Forum Discussion
Calendar heat map
Thanks Greg_Deckler
Looks like what I want, I only have a start date and end date in separate columns and looks like I would need to add a lot of multiple columns in power query for each day in order to get it to work. Was hoping there was something that could just plot it much like planer does with a start and end date to save expanding for each day to plot.
Thanks Greg_Deckler
Looks like what I want, I only have a start date and end date in separate columns and looks like I would need to add a lot of multiple columns in power query for each day in order to get it to work. Was hoping there was something that could just plot it much like planer does with a start and end date to save expanding for each day to plot.
- Greg_Deckler
Community Champion
LewyNZ Hard to say exactly. I don't know your data. I would think you could create a Date table using CALENDAR and then a measure to do what you want but, again, I don't have your data so it is difficult to say.
Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.Hi Greg,
Managed to it to work by expanding all the days. Extra few query functions but works great.
Cheers
