Forum Discussion

Frequent Visitor

7 years ago

Solved

Text value in matrix (several text values for column group)

I have table with information about project which I need to show by Month. Initial Data looks like: | Company | Project | ProjectInfo | Month | Year | |-------------|--...

Need Help

Ashish_Mathur
7 years ago
Hi,

This is the result i cam up with. You may download my PBI file from here.

Hope this helps.

Dmitriy

Frequent Visitor

7 years ago

AlB,

Thank you for answer, if I got you correctly, this will retun values in 1 row.
But it means that I can't add color conditional formatting, because it works on whole cell and not for each position of my data inside this cell.

Does it possible to make this with such way?

                  |  september  |    october     |    october   |
Company1          |-------------|----------------|--------------|
	Project1  |    text1    |    text2   	 |     text3    |
	Project1  |             |                |     text4    |

Or is not possible in matrix and it will be grouped by Project1 for 1 row anyway?