Only show Value of column on top level row in Matrix visual

[jdubs]

I have a value (in this case a date) that I only want to show on the top level row in a Matrix visual. Is this possible?

In this screenshot I only want the date in the row that is bold to show. 

[Anonymous · Accepted solution]

Hi @jdubs ,

If I understand correctly, the issue is that you want to show on the top level row in a matrix visual. Please try the following methods and check if they can solve your problem:

1.Create the simple table.

2.In the Power Query editor, choose the DateT table.

3.Select Keep Rows in the Home pane and choose keep top rows.

4.Enter the number of one row and choose apply.

5.The result is shown below.

Looking forward to your reply.

Best Regards,

Wisdom Wu

[amitchandak]

@jdubs , Use Index function, but you need combination to make it first number

or use rownumber and filter for 1

Top/Bottom Performer by name and value- https://youtu.be/HPhzzCwe10U

New DAX Function: Rownumber- https://www.youtube.com/watch?v=yS9-IQjUDwg&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L&index=1