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,
I have been looking to create an inflow/outflow report with the below data where I am expecting a Bar Chart with Count of Numbers Opened Vs Count of Numbers Closed for each month and year.
I could achieve Opened Count Separately and Closed Count Separately. Not able to include them both in a Column Chart for showcasing the inflow vs outflow.
Any idea of achieving the same?
Thanks in Advance!
Arun
Solved! Go to Solution.
@Anonymous ,
You may refer to the post below.
@Anonymous ,
You may refer to the post below.
Hi @v-chuncz-msft ,
I tried it but it is not giving me any result and I am getting an empty chart. I used the below formula for a Calendar table:
Inflow =
VAR d =
MAX ( 'Calendar'[Date] )
RETURN
CALCULATE (
DISTINCTCOUNT ('Page 1 (2)'[Number]),
'Page 1 (2)'[Opened] = d
)
Outflow =
VAR d =
MAX('Date'[Date])
RETURN
CALCULATE(
DISTINCTCOUNT('Page 1 (2)'[Number]),
'Page 1 (2)'[Closed] = d
)
Am I missing something?
Thanks,
Arun
I figured out what I was doing as wrong. I need to ensure that the format of the columns should match one another.
FORMAT should MM/DD/YYYY for all the date fields even on the calendar for it to work.
I was trying to match MMM/YYYY with MM/DD/YYYY.
Now it has been corrected and it is working as it should.
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 |