Forum Discussion

vr_2020's avatar
vr_2020
Frequent Visitor
5 years ago
Solved

Sorting X-Axis and Y-Axis values in Clustered Column Chart

Hi, Can someone please help me with Sorting in Clustered Column Chart in Power BI?   I have the following scenario built in Excel, and trying to replicate the same in Power BI. On Excel   ...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi vr_2020 ,

     

    Refer this method.

    Create a coulmn as below and it to Tooltips, then use it as sort value.

    Column = 
var rnk1 = RANKX(FILTER('Table','Table'[Column2]=EARLIER('Table'[Column2])),'Table'[Column1],,ASC,Dense)*100
var rnk2 = RANKX(FILTER('Table','Table'[Column1]=EARLIER('Table'[Column1])),'Table'[Column3],,ASC,Dense)
return
rnk1+rnk2

     

    Best Regards,

    Jay

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi vr_2020 ,

 

Refer this method.

Create a coulmn as below and it to Tooltips, then use it as sort value.

Column = 
var rnk1 = RANKX(FILTER('Table','Table'[Column2]=EARLIER('Table'[Column2])),'Table'[Column1],,ASC,Dense)*100
var rnk2 = RANKX(FILTER('Table','Table'[Column1]=EARLIER('Table'[Column1])),'Table'[Column3],,ASC,Dense)
return
rnk1+rnk2

 

Best Regards,

Jay

vr_2020's avatar
vr_2020
Frequent Visitor
5 years ago

Great, Thanks a lot Anonymous .  It worked, while I try to use excel as source in PBI Desktop and believe this DAX works when we import the data from any database in PBI Desktop

 

 

My bad, I had to mention in my original post that I am using Snowflake as datasource and trying to create visual in PBI Desktop through Direct Query. Hence, when I try to use this DAX getting "RANKX is not supported in Direct Query mode" . Any option throught Direct Query mode?

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi vr_2020 ,

     

    You may try creating a measure instead of the calculated column. The rest steps should be the same. I haven't tried it yet but it's worth a try.

     

    Best Regards,

    Jay