Johannesburg Power BI User Group Meeting
For the last event of 2022, we present episode 6 of the Brick-by-Brick series: The Final Destination. Presenting will be James McGillivray from Cobalt Analytics on "Power BI Design for the Aesthetically Challenged." In the BI flash Keamo Matlala will host a discussion on the pros, cons and how-to's of implementing report tooltip pages. Finally, since this is the final event for the year, we'll also be running a few surveys at the end of the session on the experiences from 2022 and how we'll continue to improve the user group for 2023. Agenda: BI News - Siya Zungu Brick-by-Brick Episode 6: The Final Destination - James McGillivray BI Flash: Report tooltip pages - Keamo Matlala As usual, pizza and beverages will be served so please RSVP.
Building With Power BI
Building with Power BI is a new monthly series where industry experts take us behind the scenes of an end-to-end Power BI project. From choosing the dataset to shaping the data model, applying DAX, and designing a final interactive dashboard, you’ll see exactly how professionals think through real-world projects step by step. This hands-on learning experience is designed to help you bridge the gap between theory and practice, providing you with practical insights that you can apply immediately in your own work.Building With Power BI
Building with Power BI is a new monthly series where industry experts take us behind the scenes of an end-to-end Power BI project. From choosing the dataset to shaping the data model, applying DAX, and designing a final interactive dashboard, you’ll see exactly how professionals think through real-world projects step by step. This hands-on learning experience is designed to help you bridge the gap between theory and practice, providing you with practical insights that you can apply immediately in your own work.
sidebar that grows vertically (Align containers)
I am working on a power BI Paginated Report in Report builder: I have got 2 Rectanges (containers). The main container is in yellow. It contains 3 textboxes, a table and the red container. then there is the red container (which is inside the yellow container) that contains an image and a textbox in purple. I want the red container to be aligned with the yellow one. It needs to grow vertically and dynamically depending on the table and the textboxes sizes. As you can see circled in the image below the red container does not grow vertically and dynamically (it needs to fill the space circled in blue) alongside the table and textboxes with expressions. how can I make the red container the same height as the yellow one dynamically ? Basically my main goal for the red container is to act like a side bar. Keep in mind that I am using multiple datasets and I will use multiple tables. Thank you for your help in advance.
Comparison of two different KPIs on a single report page based on user selection
Hi! I have a big dataset with more than 50 KPIs in it. The KPIs can have different data formats ($, whole numbers, percentages,...). The report consumers want to be able to select any two KPIs of the model and have the trend of these two KPIs shown on a single report page. How can I do this? I can design a page where users select only one KPI using calculation groups (according to: https://www.sqlbi.com/articles/introducing-calculation-groups/ I use calculation groups, because the KPIs have different data-formats). But I couldn't figure out how to design a page, where the users can chose two KPIs.... Thanks for your help in advance!
