Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
I can't figure out a way to visually group small elements of a treemap into big one based on a certain condition.
Example:
I have a treemap that represents sales values per product category. Data represented as % from the total. I want any section, where the % is less than one to be grouped into one large section "Other product categories".
Is it possible to do this on the level of the visualization, without actually changing the data source itself?
If yes, how?
Thanks
You cannot do this using the Treemap visual alone. You would have to arrange this either using the built-in Group functionality or dynamically with DAX.
You should be able to do this with a pretty simple Calculated Column.
Something like
Column = IF(Sales[Percent] <= 1,"Other Product Categories",Sales[CatGrp])
Hi,
I can't figure out the visual grouping of elements, without adding columns to the data itself.
Example: I have a treemap representing sales per product category and data shown as % from a total. I want any category, where the % from total is less than 1, to be grouped into one big section, represented in a treemap as "Other categories"
Thanks
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |