Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi, don't know if this is possible, but im trying to shade the background(Grey) of one specific quarter in a line graph. Trying to highlight the current quarter in a specific set of periods to help end-users understand which is the current quarter.
Any thoughts, or work arounds would be greatly appreciated!
Solved! Go to Solution.
Hi, @asalazarjr
You can try 'line and clustered chart'.
Use the value of the background height as the column value , and create a new measure to dynamically set the data color of the column.
Data colors of default color =
IF (
YEAR ( TODAY () ) = SELECTEDVALUE ( Table1[Date].[Year] )&&
QUARTER ( TODAY () ) = SELECTEDVALUE ( Table1[Date].[QuarterNo] ),
1,
0
)
Reduce the inner padding to 0, you can get a similar visual.
Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @asalazarjr
You can try 'line and clustered chart'.
Use the value of the background height as the column value , and create a new measure to dynamically set the data color of the column.
Data colors of default color =
IF (
YEAR ( TODAY () ) = SELECTEDVALUE ( Table1[Date].[Year] )&&
QUARTER ( TODAY () ) = SELECTEDVALUE ( Table1[Date].[QuarterNo] ),
1,
0
)
Reduce the inner padding to 0, you can get a similar visual.
Please check my sample file for more details.
Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@asalazarjr
Check this video, hope it can be adapted for your scenario.
https://www.youtube.com/watch?v=Ds8Twy4VvzU
⭕ Subscribe and learn Power BI from these videos
⚪ Website ⚪ LinkedIn ⚪ PBI User Group
User | Count |
---|---|
86 | |
82 | |
68 | |
66 | |
55 |
User | Count |
---|---|
123 | |
100 | |
90 | |
83 | |
66 |