Getting zero data columns to appear in a visual

[JediMole]

Google Foo is failing me on this one, and I feel like this should be possible.  The question text visual has three columns with zero data as you can see in the filters paneand I've also told the visual to items with no data.  So what gives here!?

[Bibiano_Geraldo · Accepted solution]

Hi @JediMole ,

That should work if you’ve enabled the “Show items with no data” option, as I’ve done, and it’s working perfectly, as shown below.

One suggestion I can offer is to double-check the slicers and other filters applied, as they might be affecting your final result.

To troubleshoot, try creating a new page and copying your visual there. If the issue doesn’t persist, it means the filters on your current page are influencing the result.

I hope this helps! 🎯
If you found this answer helpful:
✔️ Mark it as the solution to help others find it faster.
👍 Give it a kudo to show your appreciation!

[Anonymous · Accepted solution]

Hi @JediMole ,

You could add an Answer table and use the answer as columns.

1\Create an Anser table

Answer = 
DATATABLE(
    "Answer", STRING,
    {
        {"Excellent"},
        {"Good"},
        {"Fail"},
        {"Poor"},
        {"Unsatisfactory"}
    }
)

2\Relate these two tables

3\Set the Matrix

Best Regards,

Bof

[Bibiano_Geraldo · Accepted solution]

Hi @JediMole ,

That should work if you’ve enabled the “Show items with no data” option, as I’ve done, and it’s working perfectly, as shown below.

One suggestion I can offer is to double-check the slicers and other filters applied, as they might be affecting your final result.

To troubleshoot, try creating a new page and copying your visual there. If the issue doesn’t persist, it means the filters on your current page are influencing the result.

I hope this helps! 🎯
If you found this answer helpful:
✔️ Mark it as the solution to help others find it faster.
👍 Give it a kudo to show your appreciation!