How to display text values in matrix along timeline

[Anonymous]

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

[Anonymous]

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?

[v-yalanwu-msft]

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.

[Anonymous]

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. 

[v-yalanwu-msft · Accepted 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.