Report Builder: Power BI measures behave differently in Report Builder Matrix Visualisation
I have to generate a paginated report for a matrix table. I've created dummy data as follows: Table A (storing different hierarchies of fields): Table B (storing comments in concatenated format): The DAX formula I used to allow comments to be shown at specific level: comments_measure = CALCULATE( MAX(comments[comments]), FILTER( comments, comments[selected] = SELECTEDVALUE('fact'[Alphabet])&SELECTEDVALUE('fact'[Food]) )) The results in Power BI looks like this: However when I imported the same measure in Report Builder and created the matrix visual, I get the following results: The comments for Level 1 (Alphabet) are not being reflected correctly. Any idea to get this working correctly?
Optional & Multi-Select Paginated Reports Query Parameters with Analysis Services Data Source
Hello Power BI community! I need help with parameters and paginated reports. I want to generate paginated reports from within Power BI using the Paginated Report Visual as the container. I'm using Analysis Services as a data source and need to employ DAX for the datasource. Since "report filter parameters" are slow, I prefer using "query parameters" for faster performance. My goal is to use Power BI slicers to send multi-select data and optional slicers from the Power BI page. This way, if a user doesn't make a selection, it defaults to "All." I'm struggling to find clear information or tutorials on implementing this technique. If you know of any tutorials creating parameters using DAX, please share. I appreciate any assistance. It seems that while Power BI incorporates SSRS, connecting them via parameters isn't as seamless as expected. Thanks!
