Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Hide or Show Measures on Matrix

    Posted Jun 27, 2022 08:57 AM
    Hi,

     I try to develop a such report where I can select measure that I want to show in the matrix.
     I know to do when measures are in columns but it doesn't work when I switch measures in rows.


      Is somebody already find a solution?
    BR

    ------------------------------
    david Tanchon
    Bi Manager
    ------------------------------


  • 2.  RE: Hide or Show Measures on Matrix

    Gold Contributor
    Posted Jul 02, 2022 09:55 AM
    If I understood your question well, have you tried switching on the option to show values on Rows?



    ------------------------------
    Shungu Dhlamini
    Power BI Consultant
    shungud@gmail.com
    ------------------------------



  • 3.  RE: Hide or Show Measures on Matrix

    Posted Jul 04, 2022 05:23 AM
    Hi,

    As you can see on my screenshot, I already switched on the option to show values on Rows.
    But I would lile to show or Hide measure with a visual filter.

    BR
    David


    ------------------------------
    David Tanchon
    Bi Manager
    ------------------------------



  • 4.  RE: Hide or Show Measures on Matrix

    Posted Jul 03, 2022 09:27 PM
    Tente usar o parâmetro de campo



    ------------------------------
    Vilmar Santos
    ------------------------------



  • 5.  RE: Hide or Show Measures on Matrix

    Posted Jul 04, 2022 05:25 AM
    Hi,

      what do you mean?
      Could you provide an example, please?

    BR

    ------------------------------
    david Tanchon
    Bi Manager
    ------------------------------



  • 6.  RE: Hide or Show Measures on Matrix
    Best Answer

    Gold Contributor
    Posted Jul 04, 2022 11:49 AM

    My bad David with regards showing the measures on rows versus column. I think what @Vilmar Santos is pointing to is the new feature which allows for exactly what you are looking for. Field parameters "allow users to dynamically change the measures or dimensions being analyzed within a report. This feature can help your end-users explore and customize the analysis of the report by selecting the different measures or dimensions they are interested in."

    https://powerbi.microsoft.com/en-us/blog/power-bi-may-2022-feature-summary/​​



    ------------------------------
    Shungu Dhlamini
    Power BI Consultant
    shungud@gmail.com
    ------------------------------



  • 7.  RE: Hide or Show Measures on Matrix

    Posted Jul 05, 2022 02:05 AM
    Thanks a lot Vilmar and Shungu, it's what I'm looking for.
    I misses this new feature.

    ------------------------------
    david Tanchon
    Bi Manager
    ------------------------------