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.
hey expert i created a measure and dropped in table .From slicer i selected a specific region but still it shows data for all regions.
As in below image its showing for all regions..
I want following output with measure values related to them.
Hi @Anonymous ,
Does that make sense? If so, kindly mark the proper reply as a solution to help others having the similar issue and close the case. If not, let me know and I'll try to help you further.
Best regards
Amy
Hi @Anonymous ,
First of all, the filter will take effect when the related fields of different tables have created relationships, so you may need to create relationships between the related tables with "Both" of Cross filter direction. see more about relationship :Create and manage relationships in Power BI Desktop.
Secondly, you may change your measure formula using ALLSELECTED function instead of ALL function.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Could be numerous things. You might have an ALL in your measure formula or there could be a missing relationship.
@Greg_Deckler so is there any possibility actually i am fetching dates from slicer and then creating a measure..so can i create a dynamic column or above mentioned measure which does work wth slicers.
OK, that sounds more like a missing relationship or that somebody has inactivate interactions between visuals. Can you post an image of your data model? Is your region in the same table as your other data that you are displaying in the visual you are having issues with?
yeah actually this measure is capturing date from a slicer which is using ALLSelected function
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 |
---|---|
115 | |
99 | |
88 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |