Forum Discussion
Stratification Possible in visualizations?
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?
5 Replies
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?
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 etcHi 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 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.
