Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
I would like to change columns' view in the below chart. I need that PASS data with color green would be at the bottom of the column and FAIL data with red color would be at the top of the column. I didn't find there I could change this.
Solved! Go to Solution.
Hi, @Anonymous
As is suggested by @Greg_Deckler , I created data to reproduce your scenario.
Table:
'ISPASS' and 'Column' are calculated columns.
ISPASS =
IF(
'Table'[Score]>=80,
"PASS","Fail"
)
Column =
IF(
'Table'[Score]>=80,
1,0
)
Then you may make 'ISPASS' selected, go to 'Modeling' ribbon, click 'Sort by column' and make 'Column' selected. Finally you may get your expected result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @Anonymous
As is suggested by @Greg_Deckler , I created data to reproduce your scenario.
Table:
'ISPASS' and 'Column' are calculated columns.
ISPASS =
IF(
'Table'[Score]>=80,
"PASS","Fail"
)
Column =
IF(
'Table'[Score]>=80,
1,0
)
Then you may make 'ISPASS' selected, go to 'Modeling' ribbon, click 'Sort by column' and make 'Column' selected. Finally you may get your expected result.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I have attached a PBIX file that demonstrates.
Hi @Greg_Deckler ,
Thank you for your effort, but your solution is quite complicated to use, as I thought that there is simpler way to do that.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
96 | |
77 | |
63 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |