I’ve been working on reports using PowerBI for over a month now and it is astounding how quickly and conveniently PowerBI enables us to create rich and intuitive reports. The drill down features and cross filtering are quite impressive!
I was facing some issues in customizing the dashboard though. I would deeply appreciate your help in implementing the following:
Filters on Dashboard: My reports have common filters. Is there a way to get Filters on dashboard, for cross report filtering?
UI changes on Dashboard: I was able to successfully pin elements from my reports to a dashboard. However, they seem to lose their formatting: Color, style size. Is there a way to retain it?
Cross page filtering: The length of the page seems to be constant. However, I see we can add more pages to a report. Is there a way by which I could filter across the pages or increase size of a page, so that I can create a BIG report, all the elements having the capability to be filtered using a slicer element.
Is there a way to create a hyperlink on a report? (I know we can do that on a dashboard, can’t seem to figure out a way to do that on a report)
Please note that whenever I say filter, I want to use the Slicer Element, not the report or page level filters that we have.
I am responding on my phone while on the train. Will try my best to answer some questions.
Q1. I'm not sure if it's available yet. PowerBI did indicate they were working on Dashboard filters.
Q2. This used to be a problem. I thought PowerBI fixed this in its recent release. Best to logde a service request with them.
Q3. It is called 'Report Filter'. It is where you apply visual filters and page filters. You will notice a Report Filter. This is the only way users will be able to apply a whole report filter. 4. Yes, you can create a hyperlink. There is a hyperlink button.
Are you using PowerBi Desktop ? If you are only using the online version, then that is probably why you have had these issues.
3.Cross page filtering: The length of the page seems to be constant. However, I see we can add more pages to a report. Is there a way by which I could filter across the pages or increase size of a page, so that I can create a BIG report, all the elements having the capability to be filtered using a slicer element.
Currently, we are not able to use slicers to filter all report pages. The workaround is using Report Level Filters, it's also available in Power BI Service. If you have added a field in Report Level Filters, when you access the report, you can see Report Level Filters is available for us to check prefer value.