Forum Discussion
Calendar display
- 5 years ago
@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.