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!
