Forum Discussion
Calandar With Output Goals
Hi Anonymous,
I think matrix should be a simple choice to achieve your requirement, I haven't found custom visuals that fully matched with your requirements.
If you want to choose another way, I'd like to suggest you try to use r visual with r package and scripts to manually plot a calendar with color and show values on it.How to create color-coded calendars in R
Regards,
Xiaoxin Sheng
Anonymous ,
Please see if this visual can help
https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104381179?src=office&tab=Overview
https://blog.pragmaticworks.com/power-bi-custom-visuals-custom-calendar-by-akvelon
Other is matrix visual , weekday and month week no on column and row
Start Month = STARTOMONTH('Date'[Date])
WeekDay = WEEKDAY([Date],2) //monday
Start of Week = [Date] -[WeekDay]+1 //monday
Month Week = QUOTIENT(DATEDIFF(Minx(FILTER('Date',[Start Month]=EARLIER([Start Month])),'Date'[Start of Week]),[Date],DAY),7)+1
and conditional formatting
https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
Thanks,
I think you are correct I could do a matrix and format a calandar, but I feel as though there has to be a better way. I looked at the calandar app you linked and it is decent but would not display the numbers of the value on each date.
Hi Anonymous,
I think matrix should be a simple choice to achieve your requirement, I haven't found custom visuals that fully matched with your requirements.
If you want to choose another way, I'd like to suggest you try to use r visual with r package and scripts to manually plot a calendar with color and show values on it.How to create color-coded calendars in R
Regards,
Xiaoxin Sheng