Gráfico de Coluna
Tenho um grafico de coluna com os valores realizados e orçados. No eixo x coloquei o nome do mês e ano O problema é que quando coloco mais de um ano as colunas ficam na mesma cor para anos diferente, confundindo na hora de fazer uma analise. Tem como colocar cores diferentes para os anos?
Daily monitoring (Calendar date)
Hi All, I'm preparing a dashboard for daily monitoring on the invoice payment based on the invoice due date. Here is samply of my data: Notes: Status are compare with today date (11/10/2023) Invoice No Net Due Date Status PLSMAUS020027981 11/6/2023 Pass Due PLSMAUS020027981 11/7/2023 Pass Due US10009470 11/8/2023 Pass Due CBNP02JAN23 11/9/2023 Pass Due AC0303MAR23 11/10/2023 Today Due CBNP02JAN23 11/11/2023 Not Due AC0303MAR23 11/12/2023 Not Due CBNP02JAN23 11/13/2023 Not Due AC0303MAR23 11/14/2023 Not Due CBNP02JAN23 11/15/2023 Not Due AC0303MAR23 11/16/2023 Not Due CBNP02JAN23 11/17/2023 Not Due I want to display the cumulative status for daily monitoring. Example for date 11/10/2023, there will be data for pass due (4), today due (1), Not due (7). I create new table for calendar and link with invoice table (due date). However, its give me the chart like this: I want the chart to be like this 11/10/2023 11/11/2023 11/12/2023 11/13/2023 11/14/2023 11/15/2023 11/16/2023 11/17/2023 11/18/2023 11/19/2023 11/20/2023 11/21/2023 Pass Due 0 1 2 1 4 2 6 4 1 3 5 8 Today Due 1 1 1 1 1 1 1 1 1 1 1 1 Not Due 11 10 9 8 7 6 5 4 3 2 1 0 Can anyone assist me how to create the DAX and what the tips to make it possible. Thank you.
