Forum Discussion
How to create Dynamic reports in Power BI
Many 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.
Microsoft EmployeeHi 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
Many thanks for your reply. I am going by your idea.
I have downloaded the pbix file as well.
As per your screenshot, We can have just one slicer for selecting two different Hospital IDs. Once we select any two,Hospital IDs then we should have two bars for each Time period. Each bar is for each hospital as we are comparing values for each hospital as shown in the below screenshot.
Please guide me , how can we do this in Power BI.
- v-jiascu-msft
Hi Anonymous,
Please try to add the HospitalID in the legend. Please refer to the snapshot below. I have modified a little data to make the visual more vivid.
Best Regards,
Dale