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.
Hello everyone,
I have created a heirarchy for showing the income and outcome, but I want to remove the option of drilling through when there is no detail. For example "Total Ingresos" has detail, but "Otros ingresos (egresos), netos" has no detail. I don´t like how it looks when you star drilling. Any idea how I can fix it?
Hi @ry22749 ,
You may submit this idea or vote for the similar idea below.
Best Regards,
Jay
Community Support Team _ Jay Wang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
There is detail @ry22749 otherwise there would be no drill down. But to your point, there is only one item, so the drill down seems kind of pointless. Unfortunately, I don't know of a way to fix it short of remodeling your data a bit in Power Query or at the source to report that amount in the sub-total area vs at the detail level. I would not recommend that, but it may give you the matrix visual you are looking for.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYes, it has detail, but doesnt give you more information, its redundant.
@ry22749 , not very clear. See if this can help
https://powerbi.microsoft.com/en-us/blog/power-bi-desktop-may-2020-feature-summary/#_Cond_dest_drill
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |