Some visual cannot display the value

[mdaamirkhan]

Hi All,

I am facing an issue Some visual cannot display the value in web when i select all from the slicer. But When I select anything in the slicer then it works fine. What is the solution

[collinq]

HI @mdaamirkhan ,

My guess is that you have some non-conforming data in those columns when you do not slice the data down.  In other words, you have some "blanks" or some non-numeric data or an error data of some sort in that column of data.  I would go back to Power Query, edit that field to confirm everything is a numerical value.  In fact, once you confirm everything is numeric, I would change it to text and then do another step to change it back to numeric just to prove it is working.

[mdaamirkhan]

there is no "blanks" or non-numeric data in any columns

[collinq]

Great @mdaamirkhan ,

And were you able to change the data type to text and back to numeric (or whatever you had)?

[mdaamirkhan]

did that already but same issue 

[v-kkf-msft]

Hi @mdaamirkhan ,

When you select ALL, how do the visual in the figure below appear? 

If Total end of contract is a measure, can you share its DAX formula? What is the relationship between Organisation, LoB and Total end of contract ?

Best Regards,

Winniz