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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
Anonymous
Not applicable

How to show rank dynamically and put those rank in x axis of a chart.

Hello all,

 

I have series of data.By which i want to show the rank dynamically and put those rank into x axis and x axis will be changed according to the slicer selection..

 

Below is the data

Product No.Revenue typeRevenuePeriod
1A34Jun-18
1A720Jul-18
1A494Aug-18
1A603Sep-18
1A875Oct-18
1A601Nov-18
1B564Aug-18
1B487Sep-18
1B241Oct-18
1B124Nov-18
1B69Dec-18
1B679Jan-19
2A277Jun-18
2A890Jul-18
2A56Aug-18
2A933Sep-18
2A178Oct-18
2A485Nov-18
2D835Aug-18
2D763Sep-18
2D828Oct-18
2D677Nov-18
2D832Dec-18
2D569Jan-19

 

Rank should be calculated based on period that means, if we dont select any value in slicer then the rank should be below

 

Prod NoRevenue typePeriodRank 
1AJun-181 
1AJul-182 
1AAug-183 
1ASep-184 
1AOct-185 
1ANov-186 
1BAug-183 
1BSep-184 
1BOct-185 
1BNov-186 
1BDec-187 
1BJan-198 
2AJun-181 
2AJul-182 
2AAug-183 
2ASep-184 
2AOct-185 
2ANov-186 
2DAug-183 
2DSep-184 
2DOct-185 
2DNov-186 
2DDec-187 
2DJan-198 

 

Now let say we have sleected B from revenue type slicer, then the rank should change accordingly,

Product No.Revenue typePeriodRank
1BAug-181
1BSep-182
1BOct-183
1BNov-184
1BDec-185
1BJan-196

 

after that we would like to put this rank in x axis product no is in legend and revenue as value.that x axis will be changed according to the slicer selection.

So my expected out put is above table and one dynamic x axis chart.

 we are able to calculate rank but not able to put rank in axis..Even though we have tried by disconnected table.

 

Can anyone help us to solve this scenario please.

 

1 ACCEPTED SOLUTION
v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

It's impossible to create dynamically calculated columns in current version, please submit your idea .

Currently, only dynamic changes can be achieved in the measures, so you can consider using the table viusal to visualize the data.

 

v-lionel-msft_1-1613110350500.png

 

 

 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

2 REPLIES 2
v-lionel-msft
Community Support
Community Support

Hi @Anonymous ,

 

It's impossible to create dynamically calculated columns in current version, please submit your idea .

Currently, only dynamic changes can be achieved in the measures, so you can consider using the table viusal to visualize the data.

 

v-lionel-msft_1-1613110350500.png

 

 

 

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Anonymous
Not applicable

@v-lionel-msft ,

 

Thanks for your reply..
that thing has already been achieved..but i want to show the measure whch you have created in axis ..
i think it is not possible..

 

Thanks a lot.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.