Forum Discussion

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
3 years ago
Solved

Show Text when No Data in a Table

Hello I have a Table-Visual which has "Tracking-Numbers". Sometimes there are no data then the table is empty. Is it possible to change the empty table with a table which has a remark "No Data". ...
Need Help
Show and Tell
Tips and Tricks
  • HughLa's avatar
    HughLa
    3 years ago

    Hi Juan

     

    I am glad that it is finally working!

     

    This code should work for you:

    let
    Quelle = SharePoint.Tables("https://axa365.sharepoint.com/sites/AXA-MicrosoftTeamsService", [Implementation="2.0", ViewMode="All"]),
    #"5aaa8718-9d99-4675-9214-078e6e3131a7" = Quelle{[Id="5aaa8718-9d99-4675-9214-078e6e3131a7"]}[Items],
    #"Hinzugefügte benutzerdefinierte Spalte" = Table.AddColumn(#"5aaa8718-9d99-4675-9214-078e6e3131a7", "Custom_Summary_as_Text", each Html.Table([Summary],{{"PlainText",":root"}})),
    #"Erweiterte Custom_Summary_as_Text" = Table.ExpandTableColumn(#"Hinzugefügte benutzerdefinierte Spalte", "Custom_Summary_as_Text", {"PlainText"}, {"Custom_Summary_as_Text.PlainText"}),
    Custom1 = if Table.IsEmpty(#"Erweiterte Custom_Summary_as_Text") then Table.InsertRows(#"Erweiterte Custom_Summary_as_Text",0,{ [#"Tracking-Number" = "Table Is Empty",#"Escalated" = "False"]}) else #"Erweiterte Custom_Summary_as_Text"
in
    Custom1

     

    Let me know if it does.

     

    Regards

    Hugh

HughLa's avatar
HughLa
Icon for Resolver IV rankResolver IV
3 years ago

Yes sure! Sorry about that.

 

Here are steps to follow:

 

  1. Go to Power Query Editor (In Power BI, click on Transform Data)

     2. Select your query on in the Query pane on the left.

     3. Click on the Advanced Editor button in the Hom Tab.

     4. Add the Custom line to the M code.

 

Hugh

Heinrich's avatar
Heinrich
Icon for Post Partisan rankPost Partisan
3 years ago

Hi Hugh
Thank you but I should add this script on the table that is affected.
This table does not appear on the Query Editor.

 

As this table is a reference to another one.
How can I add the script.

 

Could you also give me a hint what the "M code" is?

 

Regards

 

Heinrich