How to Bulk Edit Measures in Power BI - With Excel Template

[@lanex1635]

I think you can change the result when you run the select measures statement in Dax studio so you don't need to copy the result table and paste in excel, Just changed the Result option on home tab to static so instead of showing the table it will generate file instead. Anyway is there a way I can do a bulk update of name of the field in measure and also the actual field?

[@tinaflemons263]

Thank you for your wonderful gift.

[@PowerBIPark]

I hope you find some use for it :)

[@data.staplz]

This will be really helpful! Appreciate it!

[@ellinikospatriotis]

Love your work, mate!

[@PowerBIPark]

Much appreciated!

[@FedexBaires]

Muchas gracias Injae!

[@PowerBIPark]

DeNada!

[@jakob2746]

The IBCS charts you did are great. Assuming we want to create 2 or more charts with various columns such as sales, quantity and inventory (comparing to past year for all of them). Would you need to create 60x 3 measures to accomplish this ? Perhaps you could do a video on how to create 3 IBCS charts with different columns as references. I would like to use the chart across all my reports but it’s not intuitive to me how I can replicate the code across multiple columns.

[@PowerBIPark]

Hi Jakob, this is such a great question. So in the IBCS, there are 3 main measures being used: _AC, _PY, _FC. The others are essentially just referencing those. So the easiest way to reuse things would be to use a field parameter or a switch measure and reference a specific measure in these 3 "base" measures. Field parameters are a bit more tricky because you need to use a workaround (you can't use selectedvalue() to reference the selection), but it would still work quite nicely :) Then you can just copy and paste the visual, and point the base measures to different ones, and you won't have to remake the visual

[@rapatel1642]

Awesome.

[@PowerBIPark]

Glad you liked it! Hopefully it saves you some hours sometime