Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
This might not be possible but if anyone has found a work around it would help loads.
I'm trying to create a column chart that is left aligned so that when it is affected by a slicer the columns line up with the matrix below.
This is the column chart and matrix unfiltered, the columns line up with the headings of the matrix underneath.
When I apply a filter for a specific year, the column is centred in the column chart and doesn't line up with the matrix.
I feel like it could be a really easy fix or just not possible at all, any help would be appreciated. Thanks in advance.
Solved! Go to Solution.
@James314 , I doubt we have control on that.
We can create a visual with independent table used in slicer,
Then you can have meausre like
if(Max([Year]), in values(Year[Year]) , [Meausre],0)
Or add +0 you measure to show all the years
[Measure] +0
@James314 , I doubt we have control on that.
We can create a visual with independent table used in slicer,
Then you can have meausre like
if(Max([Year]), in values(Year[Year]) , [Meausre],0)
Or add +0 you measure to show all the years
[Measure] +0