Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Popping bars in Bar graph based on Filter selection

Hi Experts,

 

I am working on a report which includes HospitalsID, Performance Indicators for each hospital, Measure (how indicator if performing), Statewide Average (for each indicator)

 

The report is a Line and bar graph, which has 

X axis - ReportingDate

Y Axis - Measure

 We have a filter for the IndicatorName selection and a line graph intially on top of Bar which will show each Indicator's statewide average for that  reporting period. I have duplicated HospitalID  filter twice as we want to compare the results for two hospitals. 

 

On filter selection for Hospital ID 1 , the first Bar should appear, and when we select HospitalID 2 in the second filter, second bar should appear. If the value in both filters is 'ALL' , then no bar should be visible.

 

 I did not find the option to attach the file. So, i have captured screenshots of Sample Data and Expected output.

Please advise, how can we get this visual created in Power BI. Really in need and would appreciate your help.

 

Thanks.

 

Need Help

2 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Thanks Sam for your reply.

       

      I have gone through the shared link.

      Here the requirements are little different. I want a LINE should always appear showing the Statewide Average. And then we make multiple selection in the HospitalID filter (Kindle refer to the image in the Original post) then bars (based on number of selections made)should appear representing that Hospital IDs.

      So the final visual should be a Combo chart, which have a Line(always there) and Bars which represents Hospital ID ,selected in the multiselect filter. 

      Please advise.

       

      Thanks.