Forum Discussion

MariaFlorenciaB's avatar
MariaFlorenciaB
Icon for Helper I rankHelper I
9 years ago

Macros in Power BI

Hi everyone!

I am working with the free version of Power BI. Before publishing my dashboard and share it to the users, I have to hide each formula in order not to let the users download the cube in Excel.

I am taking about 40 formulas more or less and I have to hide them every month (long story!), I can't hide the table as total because you cant do that when the formula is being used in the dashboard.

Is there any possibliity to create a MACRO in Power BI to run it and hide formulas automatically?

 

thanks in advance!!!

Need Help

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Are these formulas measures?  Could you host the measures in a separate table and simply make the table "Hide in Report View"?

     

    For each measure there is an option in the ribbon that lets you change the home table.  You can find that under the modeling tab.