Forum Discussion
Calandar With Output Goals
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?
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
3 Replies
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)+1and 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-valuesHi 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
