How to show like this in PowerBI

[Anonymous]

Hello,

Can anyone please advise on my requirements.

I have 1000 records and I want to show my data in horizontal format or like a form rather than vertical (Table view),

The user can search 1000 records based on the field "Title" as shown below,

But when they open the dashboard initially everything must show as empty and only one record can retrieve based on the search. How to acheive this?

Basically,

1) I need to visualize data as a form rather not like massive records showing one after other 

2) When no selection made (no search) everything must show as empty or wtih some message.

Thanks,

Karthik

[MFelix · Accepted solution]

Hi @Anonymous ,

There are several ways to show this you can create individual cards with each of the values or two matrix visualizations and add the individual data to each table and put them side by side.

Regarding the part of having everything cleare you can do it by adding a measure that make condittional formatting:

Condittional formatting = IF(COUNTROWS('Table') > 1 , "#00000000" )

Has you can see in the image below and in the PBIX file if you have more than one value selected the values on the right don't show:

[Anonymous]

Hey @MFelix ,

This actually fits my requirement, thank you so much.

Regards,

Karthik