Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
In my reports I have a LOT of cases where I need to put a small amount of dynamic info into the upper corner of a chart, so I used a basic table. Outside of the row headers it will mostly have only ONE row, but in some cases two (so a card won't work), and I want to "compress" it as much as possible. It will always sort (smaller to larger) on the leftmost column too, so it doesn't need to be interactive at all.
Is there a way to configure it to be "information only" with no interactivity, so the sort arrow goes away and the row and row header reclaim that "dead" space (red rectangle below) caused by the arrow?
P.S. I tried a multi-row card and it seems closer to what I have in mind, but it does not allow me to chamge column width...
Hi, @Anonymous
Is your problem solved?
Best Regards,
Caiyun Zheng
@Anonymous If you go to the "..." in top right, you can do the sort by > FY (select what is selected) to clear that arrow. Then you can simply overlay a button (with all options off to make it transparent) and the General -> Maintain layer order turned on. That will effectively make it non-clickable by the user too.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
You're right, it clears the arrow, but the dead space is still there. I am trying to make this as compact as possible, but am not having luck...
Thank for the response!
@Anonymous Ah yes, that space is kept in reserve. You could consider making it a smart narrative or the custom visual enlighten data story. That way you can format it kind of how you please without headers.
Respectfully,
Zoe Douglas (DataZoe)
Follow me on LinkedIn at https://www.linkedin.com/in/zoedouglas-data
See my reports and blog at https://www.datazoepowerbi.com/
User | Count |
---|---|
76 | |
75 | |
45 | |
31 | |
27 |
User | Count |
---|---|
99 | |
89 | |
52 | |
48 | |
46 |