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 a date table with Jan - June 2021. then another table with row of employee no and a column of corresponding month. I can filter by month and show the different employee count, my question is - how do I create a new visualisation with count of employee for each month that ignores the month filter? Is there a simple measure for this? thanks 🙂
Solved! Go to Solution.
Hi,
You have two options.
1. Use the below DAX function.
2. Stop Edit interaction with the second visual with month slicer ( Select month slicer then go to format tab click on edit interaction then click on the circle icon above. the second visual)
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
You don't need a measure for this. It's enough if you just edit the interactions between your visuals. Click the visual, go to the Format tab and then to the Edit Interactions button. On the other visual make it look like this:
You don't need a measure for this. It's enough if you just edit the interactions between your visuals. Click the visual, go to the Format tab and then to the Edit Interactions button. On the other visual make it look like this:
Hi,
You have two options.
1. Use the below DAX function.
2. Stop Edit interaction with the second visual with month slicer ( Select month slicer then go to format tab click on edit interaction then click on the circle icon above. the second visual)
Appreciate a Kudos! 🙂
If this helps and resolves the issue, please mark it as a Solution! 🙂
Regards,
N V Durga Prasad
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
39 | |
33 | |
18 | |
17 |