Forum Discussion
How to create Dynamic reports in Power BI
Hi Experts,
I am working on a dynamic report.
This report is a Line Graph which is the default view. This graph shows the Average Population in US states. It includes 2 filters called ' Select City 1' and 'Select City 2' as shown below. If user selects any value in Filters then the related bars should appear as shown below. Please help me, how can we achieve these functionality.
Many Thanks.
5 Replies
Hi Anonymous,
This is possible. Please share sample data. Mask the sensitive parts first.
What's it in the x-axis? Why does a state have three columns?
The idea is using a measure to show blank when no selection is made.
Best Regards,
DaleMany thanks for your reply.
I am sharing the Power BI file which includes the sample data which includes Hospitals, Performance Indicators for each hospital, Measure (how indicator if performing), Statewide Average (for each indicator)
X axis - ReportingDate
Y Axis - Measure
Basically we would have a filter for the IndicatorName selection and a line graph intially which will show each Indicator's statewide average for that reporting period
We need HospitalID filter twice as we want to compare the results for two hospitals.
I did not find the option to attach the file. So, i have captured screenshots of Smaple Data and Expected output.
Please advise, how can we get this visual created in Power BI. Really in need and would appreciate your help.
Hi Anonymous,
It's easy to create visuals in Power BI. You just need to drag these columns to the fields of the visual. The key issue here is the two slicers of "HospitalID". The slicers work with "AND" operator. So the result of your image isn't 81 or 24 if they have the same field from the same column. It's nothing. The solution could like it in the snapshot below.
Please download the demo from the attachment.
Best Regards,
Dale
