Forum Discussion
Calendar display
Hello community
I have a table of 3 columns (date, variable, description)
I need to display the days, only in numbers, on a chess board and have each square painted a specific color according to the values of the variable (true false)
I try to do it with a calendar display but it places me on day 1 according to the day of the week and I need to locate it first without needing to know if it is Monday Tuesday, etc ...
Is there any way to do it?
Thank you very much now
@Syndicate_Admin , There are a couple of custom visuals
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380905?tab=overview
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381179?tab=overview
Another option is to
Create these columns in the table
col ?
was _1 per cociente(day([date]),7)
Return
if(_1 to 0.7,_1)
fila - mod(day([date]),7)+1
User row as row or matrix and Col as array column.
You can do conditional formatting using a color measure
Examples
if(FIRSTNONBLANK('Table'[Value],"true")= "true","green","red") if(FIRSTNONBLANK(date[date],blank())= today(),"green","red") if(max(date[date])= tofay(),"green","red") Colour = SWITCH(TRUE(), 'Table'[Date] < TODAY(), "red", 'Table'[Date] = TODAY(), "orange", "green")Color Field - Color Measurement - 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
https://youtu.be/M5PvQUy-L_4?t=531Can you share sample data and sample output in table format? Or a sample of pbix after deleting sensitive data.
5 Replies
Syndicate_Admin , The information you have provided is not making the problem clear to me. Can you please explain with an example.
You can have new columns
Week Day = weekday([Date],1) //Sunday Week
Week Day = weekday([Date],2) //Monday Week
Appreciate your Kudos.I want to visualize it this way, and to each square (day) give it a background of green(true) or red (false) based on the data loaded in the variable column
@Syndicate_Admin , There are a couple of custom visuals
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104380905?tab=overview
https://appsource.microsoft.com/en-us/product/power-bi-visuals/wa104381179?tab=overview
Another option is to
Create these columns in the table
col ?
was _1 per cociente(day([date]),7)
Return
if(_1 to 0.7,_1)
fila - mod(day([date]),7)+1
User row as row or matrix and Col as array column.
You can do conditional formatting using a color measure
Examples
if(FIRSTNONBLANK('Table'[Value],"true")= "true","green","red") if(FIRSTNONBLANK(date[date],blank())= today(),"green","red") if(max(date[date])= tofay(),"green","red") Colour = SWITCH(TRUE(), 'Table'[Date] < TODAY(), "red", 'Table'[Date] = TODAY(), "orange", "green")Color Field - Color Measurement - 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
https://youtu.be/M5PvQUy-L_4?t=531Can you share sample data and sample output in table format? Or a sample of pbix after deleting sensitive data.
Hi Syndicate_Admin ,
You can try to use 'Calendar by Tallan' custom visual and define the color format:
Best Regards,
Community Support Team _ Yingjie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
