Data point as a table vs measure vs blanks it the matrix

[Anonymous]

Hello Experts,

I made a huge research before posting here and still have not found the correct answer. I hope someone will be able to help me.

1. I wanted to have a nice matrix table in my dashboard, so I buit a measure and - to avoid blanks - I put +0 int it (one measure is COUNT another SUM). It looks very very nice, excatly as it should.

2. To my surprice it is impossible to extract data by "data point as a table" (right mouse clicking on any value in the table and looking into source data) due to the fact that I used a measure. And this option of pointing data I desprerately need.

3. It is possible to build the same reporting by implicit measures (by dragging and dropping columns) and this option allows data pointing in the table BUT in this scenario those terrible blanks have reoccured.

Is there a way to combine all those points in one solution: not to have blaks and have option of "data point as a table" in one report? Thank you in  advance for any suggestion.

Gervazek

[v-lionel-msft]

Hi @Anonymous ,

"To my surprice it is impossible to extract data by "data point as a table" (right mouse clicking on any value in the table and looking into source data) due to the fact that I used a measure."

Is this the feature you said? I didn't reproduce your problem.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Not very clear,  You can use show item with no data , to avoid using +0