
Power Platform Clinic Episode 1
Welcome to the very first episode of Power Platform Clinic with Duncan and Ian.
In this episode:
β Topic 1 β Show/Hide Tabs Dynamically in Model Driven Apps
Ian walks through how to show or hide a whole tab in a model-driven app based on the value of a field, such as Status Reason. The demo covers:
- Why you might want to hide/show tabs
- A full explanation of the JavaScript snippet used
- How to upload and register the script in your form libraries
- Gotchas to watch out for (like needing to register the event handler onload and onchange)
- Testing the functionality and reviewing console logs to understand what’s happening under the hood
π This approach is especially useful when you only want tabs visible at specific record statuses instead of toggling individual fields.
β Topic 2 β Calculated Columns vs Measures in Power BI
Duncan takes over to demystify when to use calculated columns vs measures in Power BI, including:
- How calculated columns are stored in the model and increase dataset size
- How measures calculate dynamically based on report context
- Use cases for each, including slicing, relationships, and dynamic calculations
- Performance considerations for model refresh times and visuals
- Best practice tips on organising measures in a dedicated Measures table
π Key takeaway:
Use calculated columns when you need a static value for slicing or relationships, and measures for dynamic aggregations like KPIs and totals.
π₯ Get Involved
Have a Power Platform question you want answered on the Clinic? Drop it in the comments, reach out on LinkedIn, or send a carrier pigeon (weβre flexible).
π Thanks for watching.
If you found this episode helpful, please like, subscribe, and share to support the channel and help others in the community.
About Power Platform Clinic
A community-driven video series where Duncan Boyne and Ian Tweedie answer real questions from the Power Platform world, covering everything from Model Driven Apps to Power BI to DevOps and beyond.