Slicer issue, not displaying values in the chart section

[Anonymous]

Hi All,

I created a table of distinct values to form a one to many relationship.

The name of the table is yearweeknum. It displays the year and the week number.

For now, I have 2 weeks listed which are 2021-30 and 2021-31.

In the charts tab, when I click on 2021-30, I can see all the values for that period. 

But when I click on 2021-31, it goes blank.

What can be the problem?

Also, the 2021-31 is appended to the table which contains 2021-30.

I am new to powerBI, so any help is appreciated.

Thank you!

[amitchandak]

@Anonymous , This should not happen unless there is diff in values because of space of some character

Can you share a sample pbix after removing sensitive data.

[Anonymous]

Thank you so much for your response.

There was an error when the data was appended, hence the problem.

But I do have an other issue. I have attached the image.

The values for Alert Monitoring in the table gives the correct values for each location.

But when I use a slicer, for the yearweeknum, I get the total sum value(which is in the card visualisation).

The formula I have used is 

Alert Monitoring = CALCULATE(COUNTA('Alerts (2)'[InventoryPlanning]),'Alerts (2)'[InventoryPlanning]<>"NB")

How can I change it, so as to get the values for particular location and yearweeknum? 

[v-kelly-msft · Accepted solution]

Hi  @Anonymous ,

Try:

Alert Monitoring = CALCULATE(COUNTA('Alerts (2)'[InventoryPlanning]),FILTER(ALLSELECTED('Alerts (2)'),'Alerts (2)'[InventoryPlanning]<>"NB"))

Best Regards,
Kelly

Did I answer your question? Mark my reply as a solution!