Help with Visualization in Power BI

[rajibmahmud]

Hi, I am new in Power BI. 

I was trying to make two chart based on same set of data which are linked. So when I am selecting a particular column, in the second chart relevent bars are getting highlighted, but rest of the bars were still visible (Grey). What I am willing to do is only to see relevent bars.

Alsom when I am filtering different KPI or Measure using filter option, the filtered column/bars are still visible. Can someone please guide me? 

 

[sdjensen · Accepted solution]

Sounds like you need to handle visual interactions. You can read more about how here.... https://powerbi.microsoft.com/en-us/documentation/powerbi-service-visual-interactions/

[rajibmahmud]

Thanks a lot. It helped a lot 🙂

Sorry for this noob question.

Also, will you be able to help me with below queries?

1. How to calculate contribution in BI itself from a set of data

2. For sales data how to calculate growth, where I would like to see below

a. Current Year Sales/Prior Year Sales

b. Current Year Sales for a particular Product/Prior Year Sales for a particular Product from a large set of data

3. Preparation of Scatter Chart with 3 type of calculated data from big set of data

a. Sales, Growth and Contribution -  All of this have to be calculated