Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear community,
I am facing an issues while trying to sort my matrix header sequence
What I am trying to achieve is to display my matrix header sequence starting from Current, 1 period, 2 period, 3 period, 4 period, and then Total. I have tried creating a new table and setting up the desired sequence, but I am encountering a circular dependency error when I try to sort by column.
Greatly appreciate any guidance or help that you can provide to solve this issue. If it is possible, please find my pbix file attached for your reference.
Pbix : https://drive.google.com/file/d/1jOZrjlTcDxJL3AQ15kBX8y4IYOGpoYIg/view?usp=share_link
Thank you in advance for your time and assistance!
@NickProp28 , If you same column to drive the Sort column you will get that , do it like
Col 1 = [Col]
Col sort = <Sort logic based on Col>
Then Mark Col Sort as Col1 Sort column and use col1 in visual
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c
User | Count |
---|---|
102 | |
91 | |
85 | |
77 | |
71 |
User | Count |
---|---|
113 | |
105 | |
101 | |
75 | |
64 |