Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
It's not possible to sort the way I want to in a matrix. To drill down to what I need, I have to put a count value in, right click on the count, and click "See Records."
What I want to do instead is have a table with only rows so that my sorting stays right. But there's one field I don't want to bring in, but I want the user for any given record to be able to drill down to see this field. basically, it's a notes field but there can be many notes for any given record and I don't want to bring that field in because it will cause the records to repeat where there is more than one. What is the best way to do this?
You could use a drill-through filter and a have a page that takes them to another sheet with the notes. Or you could create a tooltip page that has the notes on it.
Drill-through: https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough
Tooltip: https://docs.microsoft.com/en-us/power-bi/desktop-tooltips
Unfortunately, it appears non-matrix table visualization does not support tooltips. I added a tooltip but it never showed up under my visualization formatting tab, so I guess it's not allowed. But tooltips look cool. The other link you provide didn't work, but I will continue to try to figure this out. Thanks. my visualization even though it does show up on the
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 |
---|---|
109 | |
102 | |
84 | |
79 | |
70 |
User | Count |
---|---|
120 | |
110 | |
95 | |
82 | |
77 |