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'm having trouble with my date slicer to coincide with the measures I have in a clustered column chart.
Goal - I want to see on the clustered column chart, 2 measures: people who start, 'Starters', and people who left the company, 'Leavers'. These are on the Y axis. The area of the company they left is on the X axis.
Measures being used:
The measures seem to work, but the issue is when I put a date slicer on the page; as it's still using whichever relationship is active, it's filtering the visuals to the incorrect numbers; e.g: if the 'Dates'[Date] to 'All Postholding w/ Projected End Date History'[ph end Date] is active, the leavers number is correct but the starters is wrong and I get the following:
S= Starters, L = Leavers
Drill-through to a 'Leavers - Data' page where the 'Leavers' measure goes to and has table above
But then if Date'[Date] to 'All Postholding w/ Projected End Date History'[Emp Start Date] relationship is active I get the following:
Drill-through to a 'Starters - Data' page where the 'Starters' measure goes to and has table above.
How do I get the date slicer to just let me pick between two dates, and I get the correct number of starters or leavers on the column chart, and when I right-click drill-through, the relevant measure I'm drilling through with takes me to the appropriate page with the right data?
Thanks in advance, I hope all the information is clear enough!
Solved! Go to Solution.
@Anonymous , Refer my blog on the same topic
Attached file after signature if needed
@Anonymous , Refer my blog on the same topic
Attached file after signature if needed
thanks @amitchandak
I don't think I wrote the DAX in the measures to be optimal, but your article got me to a working solution 👍
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 |
---|---|
49 | |
26 | |
21 | |
16 | |
12 |
User | Count |
---|---|
57 | |
49 | |
44 | |
19 | |
18 |