Show measures on rows & hiding rows when empty

[ReneDH]

I've got the following question.

In my dataset I have multiple measures which are calculating volumes across different product groups.
In the dataset there are also multiple locations.

For example, location A can produce product group 1 & 2, Location B produces product group 1, 2 & 3, and location C produces only product group 2. Every productgroup has it's own measure to calculate the volume for that measure.

I've created a matrix table and added in the value section my 3 different measures.
Then I select on formatting tab, values and show on rows.
I will get the following visual:

But in this overview I've got a lot of information which is not nessecary. 
Because some locations are not creating certain product groups, so how can I remove those product groups whilst they are empty?

[Anonymous]

HI @ReneDH,

AFAIK, power bi matrix visual will auto-hide the records if the whole field(row/column) blank.

Did any other fields exist in your chart that expand the records or chooses the 'show item with no data' option on category?

If that is the case, you can write a measure filter to check and filter records or turn off the options.

Applying a measure filter in Power BI - SQLBI

Regards,

Xiaoxin Sheng

[AlexisOlson]

So Product 1, Product 2, and Product 3 are the three different measures? This seems like an odd way of doing things rather than having one measure with Product being a dimension. With measures acting like a dimension, you can't hide blank measures, as far as I know. Dimensions can collapse but measures don't.