Data Formatting and Parameterized report

Question

Hi,&nbsp;I have a table with data as below&nbsp;ID&nbsp;&nbsp; NAME1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f3&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;expected O/p using power bi as below :&nbsp;ID&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 3&nbsp;Name&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; a&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; d&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; f&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; b&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; e&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; g&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; c&nbsp;on clicking/selecting name (a/b/c/d... etc ) it should navigate to new report and show the data related to selected name.&nbsp;whether its achievable?

v-yulgu-msft · Answer

Hi&nbsp;Rehan&nbsp;Based on my test, we cannot get the O/p table as you expected in PowerBI destop. Your second requirement&nbsp;that create a parameterized report is not available now. In PowerBI, it doesn't support the feature that on clicking one specific value,&nbsp;it navigates to a new report with that value as a parameter.&nbsp;&nbsp;If you have any other question ,please feel free to ask.&nbsp;Best regards,Yuliana Gu

Forum Discussion

Data Formatting and Parameterized report

1 Reply

Related content

Parameterizing a notebook

Parameterized connections in Data pipelines

Parameterizing connection data

History of the parameterized report

Parameterized report with native SQL queries