How to hide the total and only one column using the matrix component.

[railtons]

Hello team
I'm using the matrix component as shown in the image below:

I would like to know if there is any way to hide the "total" column of just one item. In my case, I'd like to display the total of the JPs columns, but I wouldn't like to display the total of Nbre... res.
Is there any way to hide the total of just 1 column?

Thanks 

Railton

[Anonymous]

Hi @railtons ,

As @lbendlin and @Daniel29195  said, it is possible to go through the dax function to make the value under Nbre ness show up as empty, but if you want to hide the header of this column, as far as I know, it can only be done by dragging and dropping, but this will make your matrix look rather strange.

Drag and drop to hide the table header:

you need to manually drag its column width (put the cursor near the column, as shown by the yellow arrow in the picture below, when the cursor becomes a double-arrow style, you can drag), until it is hidden.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

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

[lbendlin]

Use HASONEVALUE as a measure filter and return BLANK() if false. You will still see the column name, but you can replace that with a single dot for the totals.

[Daniel29195 · Accepted solution]

@railtons 

you can use DAX : 
step1 : create a measure as follow for the measure that you want to hide its total  

revenue new =

if(

    not ISINSCOPE(Branches[Country]), blank() , [Revenue])

this will return blank when you are on the total level for the measure you want . 

\If my response has successfully addressed your issue kindly consider marking it as the accepted solution! This will help others find it quickly. I will appreciate hitting that Kudos  button. 👍🫡

[railtons]

Hi Daniel,

Thnaks for your help. 
It works 99% 🙂
As we can see, when I click to open the line level, the value is displayed:

Another this is that I'd like to keep the total at the bottom.

Is ther another thing that can I do?


Thanks


Railton