Grafico de calor minimalista

[DIRKOPRO]

Hola chicos,

Muy buenas a todos

Soy nuevo en POWER BI y quisiera pedir su ayuda, si es posible realizar este tipo de gráficas, así de sobrias y minimalistas en POWER BI? De ser así, ¿podrían ayudarme? y que ahí donde sale el día, a la lado de este también como la fehca en formato yy-mm.

Muchas gracias por su tiempo.

[dharmendars007 · Accepted solution]

Hello @DIRKOPRO , 

1. Make sure your data is structured with at least three columns: one for the day of the week, one for the hour of the day, and one for the values (e.g., occupancy numbers in your case).

2. You may also need a date column in yy-mm format if you want to display the date next to the day.

3.In Power BI, create a Matrix Visual to organize your data.

If you want to show the day of the week along with the date in yy-mm format then you can try the below dax.

DayWithDate = FORMAT([DateColumn], "yyyy-MM") & " - " & [DayOfWeekColumn]

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[dharmendars007 · Accepted solution]

Hello @DIRKOPRO , 

1. Make sure your data is structured with at least three columns: one for the day of the week, one for the hour of the day, and one for the values (e.g., occupancy numbers in your case).

2. You may also need a date column in yy-mm format if you want to display the date next to the day.

3.In Power BI, create a Matrix Visual to organize your data.

If you want to show the day of the week along with the date in yy-mm format then you can try the below dax.

DayWithDate = FORMAT([DateColumn], "yyyy-MM") & " - " & [DayOfWeekColumn]

If you find this helpful , please mark it as solution which will be helpful for others and Your Kudos/Likes are much appreciated!

Thank You

Dharmendar S

LinkedIN 

[DIRKOPRO]

Hello, thanks for your message, I think your comment was correct, however, I want to know how to make that type of graphics as shown in the attached images, which is shown in Power Bi

[Anonymous · Accepted solution]

Hi  @DIRKOPRO ,

According to your statement, I think you can try to create a matrix visual as dharmendars007 mentioned before.

Then you can try conditional formatting to set the color.

For reference: Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.