Power Bi Table

[BIswajit_Das]

I have a table like

x

0-5%

6-10%

11-20%

21-30%

31-50%

51-60%

but my table view cames like

x

0-5%

11-20%

21-30%

31-50%

51-60%

6-10%

so how to show this in order and want apply conditional formatting to color low to high

Is there a way to do this?

[BIswajit_Das · Accepted solution]

To order the table can add a conditional column like

Then go to the visual and select the custom column and click on the sortby custom column.

Outcome

Then to add conditional coloring we can create a measure with

Color =
var selected_status = SELECTEDVALUE('Table'[GroupPerventage])
return
if(selected_status="0-5%","#f7eb9e",if(selected_status="6-10%","#f2e58d",if(selected_status="11-20%","#f5cc18",if(selected_status="21-30%","#e3ba07",IF(selected_status="31-40%","#f0b52e",IF(selected_status="41-50%","#db9f14",IF(selected_status="51-60%","#ba8711",IF(selected_status="Above 61%","#996f0e" ))))))))

Then choose the conditional color for the column with "find value" and add "color" measure as it's value to apply the coloring

i.e.
Required Data With Visual

Thank you.

[FreemanZ]

hi @BIswajit_Das 

try change it to

5%

10％

20%

30%

50%

60%

[BIswajit_Das]

Table                    Table Visual                Required Visual

TableVisual Table