Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

How to display text values in matrix along timeline

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

KD_PBI_DA100_0-1634823202624.png

 

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

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:

vyalanwumsft_0-1635138537308.png

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.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

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
Community Support
Community Support

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
Not applicable

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
Community Support
Community Support

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:

vyalanwumsft_0-1635138537308.png

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.