Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
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.
@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
You can try using "Beyond Soft Calendar" from Marketplace but this will work with a single month only.
Proud to be a Super User!
@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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |