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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
_JoSi_DA
Frequent Visitor

"Show items with no data" option not available for visual

Hello guys,

 

According the documentation  there should be an option "Show items with no data".
However this option is not displayed as expected for me, if I right-click on one of the value fields.
Maybe I am completely missing something here, but I cant figure it out.

Furthermore the visual I want to apply this option to is a matrix, which contains 9 rows with data.
I also added a slicer to my page in order to filter the data accordingly. When a filter is applied I always want to show all of the 9 rows, even if there does not exist any data for a certain group. Instead of hiding the rows, the corresponding values should be displayed as 0s.

_JoSi_DA_0-1665586226297.png

Currently the matrix will be reduced to only that groups, which actually contains data.

_JoSi_DA_1-1665586404947.png

Many, thanks in advance for your help.

Greetings,

Johannes

 

4 REPLIES 4
v-shex-msft
Community Support
Community Support

Hi @_JoSi_DA,

What version of the power bi desktop are you worked on? Can you please share some more detailed information about these? 
In addition, you can also share a pbix with some dummy data. They will help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

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

Hi @v-shex-msft ,

thanks for your reply.

I am using the following Version: 2.109.1021.0 32-bit (September 2022)


I guess providing dummy data, which kind of represent the data I am working with will be a little bit complex to provide. However, the values in the matrix are all based on measures I created, which are calculated according to the following logic:

ReplacementsTotal = 
var SumReplacements = CALCULATE(SUM(Table[Quantity Total]), FILTER(Table, Table[Investment Type en] = "Replacement"))
return
IF(SumReplacements = BLANK(), 0, SumReplacements)

I don't know, if this makes any difference in terms of that Power BI is not providing me the "Show items with no data"-option?!

 

For me, the actual issue I want to solve at the end is that the matrix should not be reduced/limited to only existing data for the different groups, when a filter is set. So I want always the 9 group/rows to be displayed in the maxtrix.

 

Thanks once again 🙂
Johannes

Hi @_JoSi_DA,

I suppose the 'show item with no data' feature may not work properly with measure expressions.

Normally it is used to show the blank rows do not have corresponding records and be hidden by power bi automatically.

For this scenario, you and a if statement to check if the current value is included in the range, then add +0 after your expression to force expand the blank records to zero and show in the visual.

Regards, Xiaoxin Sheng

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

Hi @v-shex-msft ,
sorry for my late response. Have not been able to test it earlier.
However adding +0 at the end of CALCULATE did not make the job either, which is suprising for me, since CALCULATE is supposed to overwrite the current filter context of the visual applied in my case by the slicer. But the matrix is still reduced to just the rows/categories, which contain data and obviously even not just 0. Any other solution? Would be really appreciated 🙂
Thanks anyway for your help.


Greetings,
Johannes

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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