Calandar With Output Goals

[Anonymous]

Hello, 

I am trying to make a dashboard that shows a calandar view and a quantity. I want to have each day be red or green based on if the quantity is higher or lower than a goal. 

This is fine and I hav esomething to do that, but the problem is it only works for a flat goal. I want to have a weekned and weekday goal. I have been using the visual tool beyondsoft calandar. 

How can I make a goal that changes based on the day?

[amitchandak]

@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

[Anonymous]

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.

[Anonymous · Accepted solution]

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