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.
I have created the matrix table visual. With 4 fields(product Name, Customer, City, Country) added into Rows & Sales in value pane.
But i need drilldown option only for the product Name, Customer column. i wan't to restrict the drill down & drill up option for city, Country column (defaultl, It should display all the time).
i'm not able to see any option for restricting the two columns. is there any possibility?
Solved! Go to Solution.
Hi @rveerasamy ,
Sorry for that drilldown only for two columns restriction is not possible now.
Maybe you can try to put the city and country to Columns, and drilldown it.
Then you can just drilldown the Rows. In the future, if you want to see the summary of cities and countries, configure it directly on the Dill On function.
If it doesn’t meet your requirement, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @rveerasamy ,
Sorry for that drilldown only for two columns restriction is not possible now.
Maybe you can try to put the city and country to Columns, and drilldown it.
Then you can just drilldown the Rows. In the future, if you want to see the summary of cities and countries, configure it directly on the Dill On function.
If it doesn’t meet your requirement, perhaps you can submit the requirement to ideas and add your comments there to make this feature coming sooner : https://ideas.powerbi.com/forums/265200-power-bi-ideas
Best regards,
Community Support Team _ zhenbw
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@rveerasamy , I doubt you can limit that. seem like no possibility.
Hi @rveerasamy ,
I think you will need to provide more details on this.
Does all of your columns have a hierarchy?
Please paste some sample data and screenshot for your matrix please. This doesn't help in any way.
Thanks,
Pragati
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 |
---|---|
97 | |
96 | |
82 | |
74 | |
66 |
User | Count |
---|---|
121 | |
105 | |
102 | |
82 | |
72 |