Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to 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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
75 | |
62 | |
51 | |
47 |
User | Count |
---|---|
213 | |
81 | |
64 | |
60 | |
56 |