Visualizations are not segregating attribute counts as desired. Counts for all attributes displayed in clustered column charts the same instead of different – representing the counts for each attribute per time bucket.
I searched and didn't find a matching article 😊
Solved! Go to Solution.
You need to create a Calendar Table commun between the column
Try create a new table and insert the code
CALENDAR = ADDCOLUMNS(CALENDAR(MIN('Raw Data'[Created]),MAX('Raw Data'[Resolved])),"MOUTH", UPPER(FORMAT([Date], "mmmm")))
Then you put the mouth in X-Asis.
Choose this reply like the resolution of your problem.
I used your code to create the table. The table included Date and Month columns.
I did not get the result I was looking for so I tried to join the new table with the Raw Data table on the CREATED, RESOLVED and CLOSED fields. Still not what I was looking for.
I created another table (brute force) with DATE | DAY | MONTH | YEAR columns and still not getting the results I'm seeking. Tried joining tables on CREATED-DATE and no change.
I understand you're advising me to create a date lookup table for represent all days in the RawData Table (i.e. DateLookup). Please clarify how DateLookup should relate to RawData (i.e. are they to be joined? if yes, on which fields?) And then how to define parameters within the visual definition.
I need to have a date hierarchy available to enable drill down YEAR > MONTH > DAY.
Any assistance is much appreciated. Thanks.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.