Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hi,
I am trying to figure out how to display data like this in a visual (matrix or other custom visuals). I can do the conditional formatting but unsure how to get it plotted like this. Would appreciate any pointers..
Solved! Go to Solution.
Hi, @Anonymous ;
Not knowing your original table structure, I made a simple example to achieve the result you want, such as:
1.create a column by dax.
RANK = RANKX(FILTER(ALL('Table'),[date]=EARLIER('Table'[date])),[CATE],,DESC)
The final output is shown below:
If not, can you share simple files and more information after removing sensitive information?
1. Sample data as text or screenshots.
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yalanwu-msft I tested this today and it seems to work well. Many thanks for taking time to make the example for me. I just have one other question, how its possible to show the Date (which is the headers) at the bottom of matrix as seen in my screenshot? (I saw it in a presentation showing screenshots of a Power BI report). Normally the matrix column headers go on top. ANy suggestion?
Hi, @Anonymous ;
Is your problem solved?? If so, Would you mind accept the helpful replies as solutions? Then we are able to close the thread. More people who have the same requirement will find the solution quickly and benefit here. Thank you.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, @v-yalanwu-msft thanks for your reply earlier and apologies for no feedback sooner. I haven't had a chance to go back to that problem yet. I will be trying this sometime thi week and then let you know.
Hi, @Anonymous ;
Not knowing your original table structure, I made a simple example to achieve the result you want, such as:
1.create a column by dax.
RANK = RANKX(FILTER(ALL('Table'),[date]=EARLIER('Table'[date])),[CATE],,DESC)
The final output is shown below:
If not, can you share simple files and more information after removing sensitive information?
1. Sample data as text or screenshots.
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
134 | |
72 | |
72 | |
58 | |
54 |
User | Count |
---|---|
194 | |
95 | |
65 | |
62 | |
53 |