How to show Random Text in Power Bi Report [Matrix] when We have don't have data in Data Source

[Manojkumar123]

HI All,

I have a sharepoint list with contains a people picker and Status column is a choice and one knowledge topic column is a single line of text and i have some items for some people  related to knowledge topic and Status i don't have some records for people related Knowledge topic and status when i am exporting my data to BI Report Visual it shows Blank data for items which are not available in the sharepoint. but  i want to replace that Blank to some Random Text.

Any Solution Please...

Thank you.

[DiKi-I]

you can add a step in power query and add a condition if is blank then 'any text value' .

[Manojkumar123]

Thanks for Answer Dims i tried that way but it is not Working.