Forum Discussion
Show Text when No Data in a Table
- 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 Custom1Let me know if it does.
Regards
Hugh
Let me know if it works! Im curious!
Regards
Hugh
Hi Hugh
I tried it but the Table is not showing up, as the table is a reference to another one.
Is it possible to display reference tables on Power Query?
Regards
Heinrich
- HughLa3 years ago
Resolver IV
Hi Heinrich
Would you be able to share your M code for that query? Just remove any sensitive information.
Hugh
- Heinrich3 years ago
Post Partisan
Hello Hugh
I made a sample. But can not upload it. Do I have to use DropBox etc.If you question why I did some extra tables is because of filtering.
Here the explanation. Solved: Re: Filter Data - Microsoft Power BI Community
Thank you
Heinrich
- HughLa3 years ago
Resolver IV
Hi Heinrich
Yes, can you upload it to DropBox and share the link.
Hugh