Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
My data model consists of three tables:
When I create a visual with all staff for a sales period Power BI returns 11 names, which is correct:
However, when I add the total sales for the sales people, three sales staff with no sales for the period drop off:
Any idea how I can include these in the table with showing just a blank field for sales? The are currently no filters applied to the visual other than the date of sale.
Thanks
Solved! Go to Solution.
@Anonymous - There should be an option to show items with no data. Otherwise, you can often get around this by doing something like this:
Measure =
VAR __Calc = <Some calculation>
RETURN
IF(ISBLANK(__Calc),0,__Calc)
Make sure that the table field is set to don't summarise, otherwise having a blank value will cause the whole row to disappear.
@Anonymous , You can Use +0 and filter for =0
or use this option
Thanks for your suggestion @amitchandak. However, the field I was pulling did not show the "show items with no data" option.
@Anonymous - There should be an option to show items with no data. Otherwise, you can often get around this by doing something like this:
Measure =
VAR __Calc = <Some calculation>
RETURN
IF(ISBLANK(__Calc),0,__Calc)
User | Count |
---|---|
87 | |
72 | |
68 | |
63 | |
54 |
User | Count |
---|---|
98 | |
89 | |
74 | |
67 | |
62 |