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

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

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

Hey Heinrich

 

No, you should preferrably do it at the source which will be the table in your Query Editor. - In my previous message I guide you to get to that.

This is the M code:

 

 

The tables in your screenshot are DAX tables - and they are affected by the data that is returned from your Source table.

 

Here is your table - from the query editor:

 

I have create an empty table based on your table:

Then I replaced the base64 string that is genreated for that table in the original table:

Then the record returns that the table is empty:

 

Then if you look at the DAX tables that you created, it will show that the table is empty:

 

I hope that I am making sense to you.

Hugh