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,
I have to create a bar graph which shows the latest date for each month, I have currently created the chart with selecting the latest date but I would like this to happen automatically, is there a way of creating this?
Any help would be great.
Solved! Go to Solution.
Hi,
In the picture, you will see the source data and the actual result. You may download my PBI file from here.
Hope this helps.
Hi,
In the picture, you will see the source data and the actual result. You may download my PBI file from here.
Hope this helps.
HI @zmukadam ,
In my opinion, I'd like to suggest you to add a measure to compare current date and corresponded last date and return flag. After these, you can use this measure as filter on visual level.
Measure = VAR currDate = MAX ( 'Table'[Date] ) VAR _lastdate = CALCULATE ( MAX ( 'Table'[Date] ), FILTER ( ALLSELECTED ( 'Table' ), YEAR ( 'Table'[Date] ) = YEAR ( currDate ) && MONTH ( 'Table'[Date] ) = MONTH ( currDate ) ) ) RETURN IF ( currDate = _lastdate, "Y", "N" )
Regards,
Xiaoxin Sheng
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 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |