Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi All,
Please see below snap, I want to display zero instead of blank in matrix visual in Power BI, didn't able to achieve it by using measures too (Tried sumx as well as measure+0)
This report is consist of multiple dimesnion and fact table and all the dimesnion is connected with fact with 1to* relationship,except one table i.e. dim table 3 (Dim table 3 is connected with dim table 5 on 1to* relationship and then dim table 5 is conencted with fact table on 1to* many relationship.(Creating snowflake schema)
Column from dim table 4 having 2 categories , and it is showing blank for one category if other category have data.
and if i go with measure creation, i think it didn't pass the filter context to all the tables, and if i try measure+0 then i an getting error of visual exceeds limit resource.
please help/suggest in this case on how to achieve this.
Hello power users, can anyone help on above issue ?
Hi @v-kongfanf-msft , please find below link
https://drive.google.com/file/d/1HjdG-XEy9RagVfxCHh4LtCXTUaHrZeAG/view?usp=drive_link
Hi @v-kongfan-msft , could you please help in this ?
I've placed sample PBIX file on above link
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
85 | |
83 | |
66 | |
60 | |
57 |
User | Count |
---|---|
188 | |
111 | |
105 | |
78 | |
71 |