Format Data and Navigate action with a selected parameter

[Rehan]

Hi,

I have a table with data as below

ID   NAME

1      a

1      b

1      c

2      d

2      e

3      f

3      g

expected O/p using power bi as below :

ID              1       2       3

Name        a       d      f

                  b       e      g

                  c

on clicking/selecting name (a/b/c/d... etc ) it should navigate to new report and show the data related to selected name.

whether its achievable?

[v-micsh-msft · Accepted solution]

Hi Rehan,

No, currently I don't think this is possible.

To have the ID showing in rows would need Matrix Visual in Power BI, however as the name column type is text, it can't be put into Values of the Matrix Visual. There is an idea submitted to add support for text in Martix.

Show text as values in a matrix

There is a workaround to display text in Matrix, which only works when the string returns a single value:

=if(hasonevalue(table[column]),values(table[column]))

See the thread reference: Text in a Matrix

Besides, for redirecting to other reports through clicking in the visual, currently this is not available also.

An idea for reference:

Drill to a report page

Vote for those ideas if they meet your requirements, and if you have any further questions, please feel free to post back.

Regards