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
Juramirez
Resolver I
Resolver I

Show items with no data in switch function

Hi all!

 

I just did these steps and them works fine ( I named the result column as ColumnWithSpanishMonths).

Then, I'm doing a Bar chart (Axis=ColumnWithSpanishMonths, Values=Count of value x) , the Axis field has marked the option Show items with no data but there are some months that doesn't have a value in Values Field and my Bar chart doesn't show them. How can I fix this? 

 

1 ACCEPTED SOLUTION

Hi @Juramirez,

 

Just use the formula below to create a measure to calculate the Count of WorkerID, then show the measure as Values, MonthEspañol as Axis on the Chart. Smiley Happy

Measure = COUNTA(Data[WorkerID]) + 0

m1.PNGr1.PNG

 

Here is the modified pbix file for your reference. 

 

Regards

View solution in original post

10 REPLIES 10
v-ljerr-msft
Employee
Employee

Hi @Juramirez,

 

Could try using the formula below to create a measure to calculate the Count of value x, then show the measure as ValuesColumnWithSpanishMonths as Axis on the Chart to see if it works in your scenario? Smiley Happy

Measure = COUNTA ( 'Table1'[ColumnX] ) + 0

Remark: You'll need to replace 'Table1'[ColumnX] with your real table name and column name.

 

Regards

Hi @v-ljerr-msft

 

I just did that and it stays the same. Anyone can solve this? I can't see how 😞

 

Thanks! 

Hi @Juramirez,

 

Could you share a sample pbix file(with just some sample/mock data) which can reproduce the issue, so that we can further assist on this issue? You can upload it to OneDrive or Dropbox and post the link here. Do mask sensitive data before uploading. Smiley Happy

 

Regards

Hi @v-ljerr-msft

 

I was busy, sorry for my delay. 

Here is the example: https://drive.google.com/open?id=0B8dgHywU59SkSVRyaDJocEhLMkk 

The problem is with the Group4, it doesn't have any value on count of Worker ID in "Marzo" but I want that it shows all the months on the bar chart. Any help is appreciated.

 

Thanks

Hi @Juramirez,

 

The file link provided above is not available to me. Could you reshare the sample pbix file? Smiley Happy

 

iss.PNG

 

Regards

Hi @Juramirez,

 

Just use the formula below to create a measure to calculate the Count of WorkerID, then show the measure as Values, MonthEspañol as Axis on the Chart. Smiley Happy

Measure = COUNTA(Data[WorkerID]) + 0

m1.PNGr1.PNG

 

Here is the modified pbix file for your reference. 

 

Regards

Hi @v-ljerr-msft

 

It works! Thanks a lot! To close this problem, you need to unmark the option "Show Items with no data" on axis value.

 


Regards

Anonymous
Not applicable

What is the formula for your measure?

 

Sometimes adding a +0 at the end of the formual will force the value to be 0 instead of blank, and then it will show up on the graph.

Hi @Anonymous

 

I don't have a formula for my measure, it just count the values. I tried to do that and it doesn't work. The formula is in the axis value and it's used to bring the months of date in Spanish.

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.