Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jamal29
Regular Visitor

Show items with no data on new update

Hi all,

On the previous update, to show items with no data, we simply had to go to the viz pane, click the arrow on the field and select 'Show items with no data'.


The problem I have is that there is no option for this on the latest version and I need to show all the line items on a table even if it doesn't have values without adding IF and IFBLANK DAX onto my measures.

1 ACCEPTED SOLUTION

You would then have to create a DAX measure to test if selected attribute related to value has no value. We have used this for a SUM:

ValueNoValue SUMx = SUMX( 'TableName', Sum( TableName[ColumnToSum] ) + )

View solution in original post

6 REPLIES 6
v-shex-msft
Community Support
Community Support

HI @jamal29,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

For example:
The version of power bi desktop that you tested. Power bi desktop or power bi report service optimate version? The Visual type and detail operation steps to reproduce this issue.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.
3CloudThomas
Super User
Super User

Hi but I have already seen this page. This only shows the previous Power BI version and excludes the newer version.

'By default, Power BI will not show items with no data in a chart. However, you can change this behavior and display items with no data in the "Format" tab in the Visualizations pane. You need to expand the "X-Axis"  section.Look for the "Include empty categories" option and turn it on by toggling the switch to the right.'

show items with no data - Microsoft Fabric Community

I am working on a table so there is no x axis, however i converted it to a chart and I don't see the 'Include empty categories' option.
None the less i have to use a TABLE/ MATRIX TABLE as I am creating financial statements.

You would then have to create a DAX measure to test if selected attribute related to value has no value. We have used this for a SUM:

ValueNoValue SUMx = SUMX( 'TableName', Sum( TableName[ColumnToSum] ) + )

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.