Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Re arrange the hierarchy way

Hi ,

Need and help to create a hierarchy of by order 

 

A - 50

C- 150

B-100

D- 200

 

I want chart as 

 

A - 50 

B-100

C-150

D-200

 

kindly help iF with formula or any ways o create measures with proper order 

 

kindly help me please

 

Thanks 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

hi @Anonymous 

 

See, i create one Conditional column by using that column you can Sort.

 

here,i'm sharing my screenshots. please check it once. 

 

Capture.JPGCapture1.JPGCapture2.JPG

 

regards,

Naveen

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

hi @Anonymous 

 

what do you first of i am not understanding Your requirment ?

 

-->you want visualization ? or table ? or slicer?

-->your mention hierarchy ?( why u need hierarchy, it'll showing normal order wise

-->See this is your data

Capture1.JPG

 

-->By using this data i created sample Chart, Slicer and table.

--> slicer and table i am not doing any sorting order, but it'll showing order wise

--> Coming to the chart visualization i only do it sorted.

 

Capture.JPG

 

regards,

Naveen

 

Anonymous
Not applicable

Hi @Anonymous ,

 

see i have sorted it but its not sorted by order 

 

Please guide me to sort by order

 

0-1k , 1k-5k,5k-10k, 10k+

da.PNG

Anonymous
Not applicable

hi @Anonymous 

 

See, i create one Conditional column by using that column you can Sort.

 

here,i'm sharing my screenshots. please check it once. 

 

Capture.JPGCapture1.JPGCapture2.JPG

 

regards,

Naveen

Anonymous
Not applicable

Hi  @Anonymous ,

 

Thanks a lot for help it solved my query.

Helpful resources

Announcements
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.