Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
Hi! I want to hide the first column (which comes from the 'Columns' field) in a matrix visual I've created which shows a list of KPIs (I set the matrix so that values are shown on rows. I switched off word wrap and dragged the column so that it's size is 0 but there's still this annoying gap and white line representing where the column is, but I want it gone completely (for tidiness). Can anyone help?
Thanks!
Ben
@BenjyPowerBI I don't know of a way to get rid of it completely if you're using multiple measures in values.
I'm not sure what your goal is though or what all the different rows relate to? It could be helpful to rename the measures and keep that first column so users know what they're looking at? I may be totally off base though since I don't know the context of your question.
Copying DAX from this post? Click here for a hack to quickly replace it with your own table names
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C
I work as a Microsoft trainer and consultant, specialising in Power BI and Power Query.
www.excelwithallison.com
Thanks for the speedy reply Allison! So basically I've got the KPIs names within a separate matrix (aligned with this one). This matrix just shows how much the values have changed compared to the same period last year, and the year before that, so I want to avoid repeating the KPI names (which are also quite long).
User | Count |
---|---|
84 | |
76 | |
71 | |
48 | |
39 |
User | Count |
---|---|
111 | |
56 | |
51 | |
42 | |
41 |