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

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
MarkD1722
Helper I
Helper I

One specific set of data does not display columns except when the slicer is set

I have a very unusual situation with a stacked column chart that I have not seen before.  I have a set of values that I am summing up by Location and plotting along an axis that is the week numbers in the year (i.e., Weeks 1 thru 52).  Also, the data that is displaying has a dimension called Status that is part of the mystery.  There is a table below that lists all the results of whatever is displaying in the chart.  There is also a count of the projects at the top of the page that displays the number of projects that should display in the chart and in the table.

As far as I can tell, one specific location's data (let's call this Location A) is operating counterintuitively to the other locations' datas.  Location A's data does not display on the chart with all the other locations.  Instead the data for this only displays if the Status slicer has the "Approved" status selected (the box has to be checked).  For all other projects, where the Status is "Approved," those columns display as expected when no status are selected or when "All selected" is checked.  Why would this be?  Examination of all the filters, nothing is revealed that should affect this single Location differently.   Here is what it looks like (sorry for all the redactions) with all the statuses selected for Location A:

MarkD1722_0-1723144673703.png


Now when I select "Approved" in the Status slicer, I get the following (again, sorry for redactions):

 

MarkD1722_2-1723145382002.png

 

I cannot understand why this is working this way specifically for this one location.   The values are being calculated using a SWITCH function keyed off the Status (nothing with Location), but the other sites' projects are not behaving like this--they display as you would expect, when the slicer is null or "Select all" is selected.  I have reviewed this with a colleague and they are equally bewildered.  Probably something really simple, but it is evading us as we see no difference with this particular location.  Any thoughts on what might be happening or how to better troubleshoot?

Thanks.



1 ACCEPTED SOLUTION

Thanks, @HotChilli .  Your questions are spot on.  We figured it out with a fresh set of eyes.  Within the switch function, there was no provision for particularly infrequent status that is ultimately supposed to be filtered out.  That location in question happened to have a couple projects with this unusual status, and the switch function appeared to return a completely null set.  I added a line to deal with that status and everything appeared as expected.

View solution in original post

3 REPLIES 3
HotChilli
Super User
Super User

" The values are being calculated using a SWITCH function keyed off the Status (nothing with Location), but the other sites' projects are not behaving like this"

This, along with the overall description,  is all a little too cryptic to help you.

Start with the basics: What tables do you have? What are the relationships? What's the measure definition?

What filters and slicers affect the visual?

If you can't tell us any of this it's going to be difficult to help.

Thanks, @HotChilli .  Your questions are spot on.  We figured it out with a fresh set of eyes.  Within the switch function, there was no provision for particularly infrequent status that is ultimately supposed to be filtered out.  That location in question happened to have a couple projects with this unusual status, and the switch function appeared to return a completely null set.  I added a line to deal with that status and everything appeared as expected.

Hi @MarkD1722,

Congratulations on solving this issue and thanks for sharing your solution.

 

Please remember to accept your solution as answer.

 

It will do great help to those who meet the similar question in this forum.

 

Thanks again for your contribution.

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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