Forum Discussion

andrew_k's avatar
andrew_k
Icon for Helper I rankHelper I
2 years ago

Problem displaying records with no data (as 0) in Power BI visual

Hi Community I am struggling to get my Power BI visual to display items (which have no data) as '0'.   My data model contains a hierachy (1. Business Area, 2. Department) I have a total of 36 De...
Need Help
Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
2 years ago

Hi,

I will have to see your file.

andrew_k's avatar
andrew_k
Icon for Helper I rankHelper I
2 years ago

Now shared via my proton drive as I was unable to upload it.

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    2 years ago

    Hi,

    The reason you are facing this problem is that there are different Dim Table of Employees, Department and Business Areas. I think the solution would be to set the cross filter direction to Both but i am not sure.  Hope someone can help here.

    • andrew_k's avatar
      andrew_k
      Icon for Helper I rankHelper I
      2 years ago

      The Employees table did previously contain the department and business areas but I split it out to further normalise my model. I did try to experiment with the cross filter direction but this didn't work.