cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ShanayaK Helper IV
Helper IV

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)

 

TestData.png

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. 

 

Power BI R&D.png

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.

 

2 REPLIES 2
Community Support
Community Support

Re: Popping bars in Bar graph based on Filter selection

@ShanayaK,

 

You may take a look at the following post.

https://community.powerbi.com/t5/Desktop/When-no-values-selected-in-a-multi-item-slicer-show-nothing...

Community Support Team _ Sam Zha
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
ShanayaK Helper IV
Helper IV

Re: Popping bars in Bar graph based on Filter selection

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.

 

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Solution Authors
Top Kudoed Authors