Remove blanks after measure in hierachy

[mirkoslav]

Hi,

I have 3 problems whith which I'm fighting for last 10 days and need help to solving them:

a) I cannot remove blanks after calculated row (measure) when my report has hierarchy and in hiearchy structure some of the calculated rows don't have sublevels. What I'm doing wrong?

b) I'm trying to show values in original currency (doesn't matter which is) and in EURo depending on slicer. For instance if I choose EUR, values should be automaticaly calculated into EURos, if EURo is not selected then values should be in original currency. I was trying to implement many different suggestion from this forum, but non was succesful. What I'm doing wrong?

c) Is it possible to hide Total row in matrix?

On link you can find my data model in pbix.

thank you for your help.

[v-jiascu-msft]

Hi @mirkoslav,

I hope you didn't share any confidential data here. Please beware of the data leak.

Please refer to the snapshot for details.

1. Change the "Cross filter direction" to "both".

2. Please try the same way that you apply the rounding. 

3. You can achieve it in the settings.

Best Regards,
Dale

[mirkoslav]

Hi @v-jiascu-msft,

thanks for warning but nor data nor structure are real, but the problem is 🙂 and thank you for your suggestions.

regarding your proposals:

1. If I change cross filter direction to both, then I'm losing rows with percentages and it is not helping. 😞

2. Will try.

3. I tried and I'm not getting result. Grand total I want to remove.

Kr,

Miro

[v-jiascu-msft · Accepted solution]

Hi Miro,

1. Please upgrade to the latest version, then you can hide the blank rows. Please refer to the snapshot below.

3. You can hide the Grand total, Please try it out.

Best Regards,
Dale

[mirkoslav]

Hi Dane,

thank you for help. I did it and it works properly now.

🙂