![]() ![]() Right now we can’t change the rectangle borders in the chart, and it can make the rectangles hard to see depending on the color used and the chart background color.Īs with categories, it would be nice to be able to allow the detail labels size to grow/shrink with the size of the rectangle. It would also be nice to be able to control the border color and width around the detail rectangles as well. I think line breaks would help with fitting information into the rectangles. What’s currently missing from measure-driven data labels is the ability to add line breaks. I’d like to see that added to treemaps as well. We recently (May 2023) got the ability to create measure-driven data labels in some visuals such as bar, column, and line charts. The other big feature I think we need is better control over the detail labels. ![]() It would also be great to be able to label the top-level category outside of the rectangles, as is shown in this treemap. Maybe that can be accomplished with border width alone, but being able to change colors would be nice. I need to be able to create good contrast between the rectangle background color, the category border, and the visual background, so it’s clear where a category ends. The color is important for accessibility. I want to be able to make the border around categories thicker and change the color. Currently, the Power BI treemap doesn’t provide me with any control over the borders around categories. Part of what makes that tree map work is that there is more space/wider borders between the top-level categories. I want to be able to make something like Figure 1 in this blog post. In Power BI today, when you expand down through multiple levels of the category hierarchy, you just get more colors (1 color per combination of values in the categories). The more important feature for me is to be able to see multiple levels of the category at once, instead of treating them like all one level when you drill down. Category names that don’t fit in the section of the treemap are truncated The other problem with drilldown and category labels is that they get truncated when they hit the edge of the category, and there is no way to have it wrap to a new line or even just make the text for that category smaller to fit without changing all category labels to be smaller. While that is a good start, it would be great to include some kind of delimiter in there so it’s easier to read e.g., “Technology | United States” or “Technology ↳ United States”. For example, if my top level is sector and my second level is country, and I choose to expand all down one level in the hierarchy, I will see a value like “Technology United States”. If you drill down from the top level, it will concatenate the category names. This is good because treemaps are really meant for large amounts of hierarchical data. Power BI allows us to include multiple categories and the ability drill up/down though them. If I remove all the tooltip fields, it takes between 1 and 2 seconds, which is much more acceptable. This seems to be related to the presence of the tooltip fields. The Power BI treemap took over 15 seconds to render If I use Performance Analyzer to capture this action, we can see the last category color change took 15463 milliseconds (15 seconds), and almost all of that time was spent on visual display. This is likely more than the average Power BI Desktop user has available to them.Ĭhanging the color of one category in the format pane consistently requires a wait time of about 14 seconds for me before the treemap finishes re-rendering. I’m running the latest version of Power BI Desktop (July 2023) on a machine with an Intel Core i9-11900H processor (8 cores/16 threads, 2.5 GHz clock speed) and 64 GB of RAM. The fields all come from an imported dataset containing a single table with 239 rows. I populated the treemap with one field in Category, one in Details, one in Values, and four fields in Tooltips. The treemap above takes a long time to render. I ended up with the treemap below, which isn’t bad, but it made me realize that the treemap is in need of some improvements to make it really useful. Originally, I had set out to make a different treemap, but I ran into some limitations with the visual. I recently created a treemap in Power BI for a Workout Wednesday challenge. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |