Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
ThomasWeppler
Impactful Individual
Impactful Individual

Meassures as groups in treemaps

I am trying to make a tree map to categorize different customers. A, B and C customers.

My formular can either be placed as a colum in the customer table, but in that case I cannot change my kalender filter from the report.

 

Alternativly I can make a measure that calculate what kind of customer we are dealing with. But in that case I cannot add it to groups and see the diffrent groups in my tree map.

 

Is there someway to solve either of the problems?

All advice and suggestions are greatly appreciated.

2 REPLIES 2
ThomasWeppler
Impactful Individual
Impactful Individual

Sure no problem.

treemaps.png

 

Here you can see a table (where the numbers has been blured out) and two tree maps one which shows the earnings from diffrent companies and another which shows the numbers of companies.

 

I want to add a date slicer which changes the dates that calculates the type of customers.

I have made this measure

Dobbelt ABC =
CALCULATE(
IF (
'Measure'[Faktureret] > 250000
&& [Avance] > 0.3,
"AA",
IF (
'Measure'[Faktureret] > 250000
&& [Avance] <= 0.3
&& [Avance] > 0.15,
"AB",
IF (
'Measure'[Faktureret] > 250000
&& [Avance] <= 0.15,
"AC",
IF (
'Measure'[Faktureret] <= 250000
&& 'Measure'[Faktureret] > 50000
&& [Avance] > 0.3,
"BA",
IF (
'Measure'[Faktureret] <= 250000
&& 'Measure'[Faktureret] > 50000
&& [Avance] <= 0.3
&& [Avance] > 0.15,
"BB",
IF (
'Measure'[Faktureret] <= 250000
&& 'Measure'[Faktureret] > 50000
&& [Avance] <= 0.15,
"BC",
IF (
'Measure'[Faktureret] <= 50000
&& [Avance] > 0.3,
"CA",
IF (
'Measure'[Faktureret] <= 50000
&& [Avance] <= 0.3
&& [Avance] > 0.15,
"CB",
"CC")))))))), Calender[month index] > -37)

But I cannot add it to the group filter on the roadmap.
I have also used the add colum buttom, to add a colum in a table instead of makeing a new filter.

New kolonne.png

This colum can be used as a group in a treemap, but I don't know if I dynamicly can change the date filter from the repport, so I have to decided on a predetermede datefilter.
I hope this made it more clear.




v-yiruan-msft
Community Support
Community Support

Hi @ThomasWeppler ,

I'm sorry I don't quite understand your needs. Could you please provide some sample data and screenshots to illustrate in detail your applied scenario and your desired end result? Do you want to filter the calendar's date field to dynamically display the data in treemap visual? Thank you.
Here are two cases on treemap related issues, hope they can help you.

Can't use treemap as filter

Interactive filtering treemap

Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.