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

[Anonymous]

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 type	Revenue	Period
1	A	34	Jun-18
1	A	720	Jul-18
1	A	494	Aug-18
1	A	603	Sep-18
1	A	875	Oct-18
1	A	601	Nov-18
1	B	564	Aug-18
1	B	487	Sep-18
1	B	241	Oct-18
1	B	124	Nov-18
1	B	69	Dec-18
1	B	679	Jan-19
2	A	277	Jun-18
2	A	890	Jul-18
2	A	56	Aug-18
2	A	933	Sep-18
2	A	178	Oct-18
2	A	485	Nov-18
2	D	835	Aug-18
2	D	763	Sep-18
2	D	828	Oct-18
2	D	677	Nov-18
2	D	832	Dec-18
2	D	569	Jan-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 No	Revenue type	Period	Rank
1	A	Jun-18	1
1	A	Jul-18	2
1	A	Aug-18	3
1	A	Sep-18	4
1	A	Oct-18	5
1	A	Nov-18	6
1	B	Aug-18	3
1	B	Sep-18	4
1	B	Oct-18	5
1	B	Nov-18	6
1	B	Dec-18	7
1	B	Jan-19	8
2	A	Jun-18	1
2	A	Jul-18	2
2	A	Aug-18	3
2	A	Sep-18	4
2	A	Oct-18	5
2	A	Nov-18	6
2	D	Aug-18	3
2	D	Sep-18	4
2	D	Oct-18	5
2	D	Nov-18	6
2	D	Dec-18	7
2	D	Jan-19	8

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

Product No.	Revenue type	Period	Rank
1	B	Aug-18	1
1	B	Sep-18	2
1	B	Oct-18	3
1	B	Nov-18	4
1	B	Dec-18	5
1	B	Jan-19	6

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.

[v-lionel-msft · Accepted solution]

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.

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]

@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.