Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Power BI Matrix

Hello, I am trying to create a matrix and I was wondering if it is possible to use a text column as a value in a matrix.  My table looks like this: *this shows services offered to each custo...
Need Help
  • MFelix's avatar
    MFelix
    6 years ago

    Hi Anonymous ,

     

    If the detail of the Invoice unit has only one value per each Service then when you select the first or the last value in the matrix should return the expected value, however if for Hours you have more than one Invoice unit then you will get incorrect values.

     

    How does your data model looks like?

MFelix's avatar
MFelix
Super User
6 years ago

Hi Anonymous ,

 

If the detail of the Invoice unit has only one value per each Service then when you select the first or the last value in the matrix should return the expected value, however if for Hours you have more than one Invoice unit then you will get incorrect values.

 

How does your data model looks like?

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi MFelix ,

You were right with this. I'm not sure what happened, but Power BI only showed one invoice unit for all services (as can be seen in my screenshot), even though each service had its unique single invoice unit. At some point, it just changed to the correct distribution, but i have no idea why. No changes were done in the data source. 

But anyway, thanks a lot!

Regards,

Ruxandra