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.
Hi all,
Two different sources, linked by dates, but can't get a visual with 2 bars each month
(green bar ok, grey bar not ok):
here is a look at the two linked dates:
thanks for your help
Solved! Go to Solution.
You should use a Date table an create relationships to both tables. Then in the chart use the Month of the Dates table to see the amounts.
Date tables must contain continuous dates.
Regards
You should create a new colum with something like STARTOFMONTH(IssuedAt) to get the same value in both tables.
Then make the relationship with the new column.
Regards
Rodrigo
@Greg_Deckler: same date type : dd/mm/yyyy. I tried with a solution you gave elsewhere like = MONTH([date]) & YEAR([date]) but I get
"Expression error: The name 'MONTH' wasn't recognized. Make sure it's spelled correctly."
@rockdrigom: "get the same value in both tables." => sure, got it, thanks!
I'm just beginnig with PBI...I get the following error:
"Expression error: The name 'STARTOFMONTH' wasn't recognized. Make sure it's spelled correctly."
I think I don't enter DAX correctly...
best,
@rockdrigom: yes in PBI. But I was in the Query Editor 🙂
Actually, it's very unclear to me when to edit data in the Query Editor and when to do it in the modeling...
Doing the formula in modeling works great, and i updated the relationship
It's getting much better :
but the grey bar doesnt display the good number for each month: either a total or average
You should use a Date table an create relationships to both tables. Then in the chart use the Month of the Dates table to see the amounts.
Date tables must contain continuous dates.
Regards
@rockdrigomThanks! This is really a best practice I hadn't read so far... Microsoft should create a tutorial to cover this. I guess the date table and country table are probably the most used.
Looks like your dates are in 2 different formats, might try making them both mm/dd/yy or dd/mm/yy. Blanks generally indicate nont-matching rows in a relationship.
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 |