Meassures as groups in treemaps

[ThomasWeppler]

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.

[ThomasWeppler]

Sure no problem.

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.

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.

 

[Anonymous]

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