Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
This is my simple data:
This is the table graph (one row is missing):
How do I make the table graph show the missing row? I tried setting the filter to "is blank" or "is 0", but it did not help.
Solved! Go to Solution.
@Zyg_D , Create measure with +0
or try this option
Hi @Zyg_D ,
I was able to re-create the same scenario as yours with one-to-many relationship and same columns taken into table viz.
Seems like your [Year] measure is at 'Don't Summarize'.
Change it to 'Sum' and your missing row should be visible.
Before(left) and After(right) image:
Don't forget to give thumbs up and Accept this as a solution if it helped you !!!
Hey @Zyg_D ,
Thanks for reaching out to the community. I think I see what is going on in your question
So I've used the same data you provided as my test data
Power BI will default to excluding blanks if you just place the different columns into a table and ask it to count
One solution is to make a measure like the following
Count of ID =
COUNT(Table1[ID])
Which will provide the following result
There are other ways to go about what you are trying to accompish - but let us know if this works for you. If not we can noodle it around some more
@Zyg_D , Create measure with +0
or try this option
@Zyg_D I think there should be an option of showing blank values for your column. Otherwise, you can aways create a measure that always return 1 and add it to your visual (and then shrink it down to hide it)
https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
93 | |
77 | |
65 | |
53 |
User | Count |
---|---|
147 | |
106 | |
104 | |
87 | |
61 |