Grouping revenue and displaying it in different visuals based on different metrics

[Anonymous]

Hello,

I have a fact table where in I have my Revenue. I need to display the revenue by metrics like Business Type, Company Type and Product Type. I also need a filter called "Revenue Range" which should contain brackets like [0-2 million],[2-6 million] and 6 million and above. This filter should filter out data for Revenue by each metric. For example, if I select Revenue-> [0-2 million], it should show me revenue by Business type, Revenue by Company type and Revenue by product type all lying between 0-2 million. I am unable to do this since I am facing relationship issue. Any help would be appreciated. Please refer to the image below for better clarity. I have cropped the X axis out cos of data security issues.

[v-chuncz-msft · Accepted solution]

@Anonymous,

You may add a separate table for Slicer and add an appropriate measure to Visual level filters.

[vanessafvg]

@Anonymous

you need to create a calculated column in your table called something like Revenue Banding

then you would need somethign like a switch statement to run it

ie.

new calculated column;

Revenue Banding =
SWITCH ( TRUE (), 

               and, revenue <= 0, revenue <= 1000, "0-1000",

              and, revenue <= 1001, revenue <=2000, "10001-2000",

             "not classified"

     )

      keep adding for each category (unclassified is to catch those that aren't in your specified conditions, can leave out)