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 am working on one Line and Stack column chart where all data are arranged by startweekdate which every sunday. Please see picture below for more info.
As you can see above, chart is based on each sunday date now, what I want is to color or shadow with Greay background on highlighted week numbers which lastest week.
All other columns values will be as it as just to highlight latest one.
Any idea on how to do it as I have never done that before?
Thanks
@damit23183 , On stacked visual, we can use conditional formatting, so that can not help
The only thing I can think of is having an additional line with marked. Where you can make the line width as 0 and the marker can highligh
New measure =
var _Sunday = max(Date[Date]) - weekday(max(Date[Date]),1) +1
return
if( max(Date[Date]) =_Sunday , [Line Measure] , blank())
Use this as a line enable marker and make line width 0
HI Amit,
Thanks for your solution but it's not working out as max date week i am getting is 31/7 instead of 10/09.
Thanks
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 |
---|---|
106 | |
104 | |
79 | |
68 | |
61 |
User | Count |
---|---|
144 | |
104 | |
103 | |
82 | |
70 |