Calendar display

[Syndicate_Admin]

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

[v-yingjl]

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.

[amitchandak]

@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.

[Syndicate_Admin]

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

[FarhanAhmed]

You can try using "Beyond Soft Calendar"  from Marketplace but this will work with a single month only. 

[amitchandak · Accepted solution]

@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-num...
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values
https://youtu.be/M5PvQUy-L_4?t=531

Can you share sample data and sample output in table format? Or a sample of pbix after deleting sensitive data.