Add blanck row in a matrix without digging on this row

[nicolast29]

Hi

I made a matrix with a sub level who show the account number used for the calculation

It works well

I want to add space between some row in order to make the visual more pleasant

I try different solutions, and i finally use a dedicated line on my matrix

My problem is that i didn't know how to avoid the sub level for thoses lines 

Because as logique, i should not have account number and value for them

Or at least to avoid the list of all accounts

Here my pbix file

https://1drv.ms/u/s!AoqtZHsX4BzvhIdzhrd9JHy81fTYPg?e=JAuJ1v

Thanks

Nicolas

[nicolast29 · Accepted solution]

hI 

I finally use profitbase visual, to do what i wanted

[amitchandak]

@nicolast29 , In power bi it can only come using data only.

But there is some options discussed here using excel and power bi app

Power bi Excel for P&L , add in app
Curbal
https://www.youtube.com/watch?v=IISYzTaIyu4
Guyinacube
https://www.youtube.com/watch?v=1yJnmZRTNZg

[nicolast29]

Hi

Thansks for the links, i love those 2 channels

i will not work like that for my case but i take it in a corner of my head for futher uses

Have a nice day

[v-rzhou-msft]

Hi @nicolast29 ,

Do you want to remove the categorys whose measures all return blank in CompteNum level?

I think you can try to create a measure and filter your visual by this measure.

Measure = 
IF( SUMX('GL Normé',[Switch C Exploit]) + SUMX('GL Normé',[Switch C Exploit %]) = 0,0,1) 

Add this measure into the visual level filter and set it to show items when value =1.

Best Regards,
Rico Zhou

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