Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

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

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.

Need Help

2 Replies

  • DiKi-I's avatar
    DiKi-I
    Icon for Post Partisan rankPost Partisan
    3 years ago

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

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