Stratification Possible in visualizations?

[cdawidow]

Hi guys, I have 4 measures to evaluate my customers, each classed as A - D. Is it possible to display this in any of the visuals currently present in power bi desktop? 

[Greg_Deckler]

@cdawidow Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882

Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.

[amitchandak]

@cdawidow , Looking at this i am not able to find what is measure, what is dimesion.  Can you share sample data and sample output in table format?

[cdawidow]

I just used measures with IF statements to get a final ranking (A,B,C OR D) 

For example, margin rank is made out of 2 factors margin $ and overall margin % .

Margin Final = IF('Customer Info'[Column]<=1,"A",IF('Customer Info'[Column]<=2,"B",IF('Customer Info'[Column]<=3,"C","D")))

I essentially copy this formual for each factor I want to measure to come up with the final ranking.  I classify A =1,B+2,C=3 and D =4 so I dont run into any errors comparing text with integers etc

[Anonymous]

Hi @cdawidow ,

What's your expected result? Do you want to get a proper visual to display the data just as the one in your screen shot? If yes, you can create a matrix and make conditional formatting for classified fields(A-D) with background color. You can refer the following documentation to do it.

Power BI Conditional Formatting for Matrix and Table Visuals

Best Regards

Rena

[cdawidow]

Yes I under stand the conditional formatting but I want to display all those 4 factors visually ideally in a scatter plot and have the names of the customers plotted within based of their individual performances of these factors.