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?
How to remove extra space in a tile without making the grid smaller?
I've created a dashboard consisting of multiple grids (reports). However, my tiles have a lot of extra empty rows under the grid. Whenever I use the resize icon on the bottom right to make the tile smaller, the table itself is being resized and becomes very small. How can I remove this extra white space without affecting the table size? Also, how can I remove this extra space in the title to align with the columns?
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.
Custom Matrix
Hi, I would build a matrix like this including 2 measures (assume costs and % of each class at category level). Is there any way to build something like this? Consider that categories are dynamic while classes are static: At the moment I have no idea about how to develop this, problably deneb could be a way... Thanks in advance
