Expand/Collapse data within a single cell in a table in Power BI

[Anonymous]

Hi Team, 

We have larger text data in a particular cell value. We wanted to see only some part of data and expand only the ones that we wish to see (i.e kind of Accordion table visualization). Can you suggest how can we implement this. 

Regards,

Anusha 

[v-yanjiang-msft]

Hi @Anonymous ,

According to your description, I create a sample.

If you means in the column1 row6, you only want to show PQR, not PQR123, you can use Split Column in PowerQuery.

In this sample, I select Split Column By Digit to Non-Digit, and get the new two columns.

Reference:Split a column of text (Power Query)

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Please refer the below as an example. We have text data only which is larger and trying to see only some part of data for each row and expand it to see the complete data only for few selected ones. 

[Samarth_18]

Hi @Anonymous ,

As far as I can understand, matrix visual fullfil your requirement here. You can refer below url for more details:-

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual

Please share some sample data with text format with expected output. It can help to give answer more specifically.

Thanks,

Samarth