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.
Hello all,
Below a simplified view of my use case :
TIME.Date = FACTS.Creation date (active relationship)
TIME.Date = FACTS.Closure date (inactive relationship)
TIME is a date table, a reference table :
FACTS is my facts table where all the orders are registered.
I would like to make appear in the same chart the quantity created and closed during the time.
I’ve created these measures :
Created orders = SUM(FACTS[Quantity])
Closed orders = CALCULATE(SUM(FACTS[Quantity]),USERELATIONSHIP(FACTS[Closure date],'TIME'[Date]))
By these measures I have this result :
With this solution, there are BLANK instead of 0 for March (for example).
So, I’ve added “+0” to the measures but futures months are now valued…
Do you know a solution permit to make appear 0 for the past months and Blank for the future months ?
Thank in advance for your help... 🙂
Solved! Go to Solution.
updated the pbix file,pls see the attachment below.
Proud to be a Super User!
Hi,
Just ensure that the Date table only goes uptil the last date that appears in the FACTS table.
Hi,
Thank you for your response.
But I would like to make appear the future months in the graph, not valued.
Hi,
Why do you want to show future months in the graph when there is no data for those future months.
Cause this is my need 😅
here is a workaround for you.
pls see the attachment below
Proud to be a Super User!
Hi,
Which version of PowerBi do you use ?
I have this result on your report :
0 is missing for March, April and May.
updated the pbix file,pls see the attachment below.
Proud to be a Super User!
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 |
---|---|
111 | |
100 | |
80 | |
64 | |
58 |
User | Count |
---|---|
148 | |
111 | |
93 | |
84 | |
66 |