Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago

filter values in array without changing the measurement values

Hello,

Is there a way to hide a value in the matrix (in this case it is an operator from the operators table) but without modifying the values?
For example, I would like to remove the Save from filters operator so that it also disappears from the matrix, but when I remove it the values of the measurements already change.

thanks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Syndicate_Admin 

     

    You seem to want to hide the display of specific values without affecting the underlying data or calculations in the report.

     

    In Power BI, this can be done by using filters or hidden items:

     

    You can apply filters to the matrix to exclude the specific operators you mentioned.

     

    Types of filters in Power BI reports - Power BI | Microsoft Learn

     

    If you want to permanently hide certain values from any report view, consider using the Hide in Report View option in Power BI Desktop.

     

    This option allows you to hide specific columns or tables in the report view.

     

    Data modeling in the default Power BI semantic model - Microsoft Fabric | Microsoft Learn

     

    Regards,

    Nono Chen

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

    • Syndicate_Admin's avatar
      Syndicate_Admin
      Administrator
      2 years ago

      Sorry but I don't see what filter it is... I've tried but nothing, as soon as I hide the values they change.
      In the following screenshots you can see how the total of the first row is 103, if I exclude the Save operator, it goes from 103 to 8. So the exclude filter does affect values, but I imagine there is another one that doesn't.