Using column name as filter along with condition

[Anonymous]

hi 

i am new to power bi , i have issue in creating charts.

i have attached sameple data in excel using that data i have created table visual like this 

now My manage asks me to show same insight in charts intead of table as shown above

i have also created charts like this 

this seems to be bit complicated as i want to create 3 charts(count of order_id, GMV TOTAL,RESOLUTION AMOUNT) for each 3  categories (IssueDescl1,Resolvedby,resolution Given) which give 9 charts which is complicated to look.

What i am planning to do is I want to create only three charts like in image shown above, and i need filter visual that shows

count of order_id

GMV TOTAL

RESOLUTION AMOUNT

if i click count of order id , then all three visual should show count of order id for each cateory and if i click resolution amount it should show Sum of Resoultion amount for all categories .

Note:

order_id - Count(distinct)

GMV TOTAL-Sum

RESOLUTION AMOUNT- Sum 

Can nany on Know how to do this

i have attched link for sample data for this problem 

https://drive.google.com/file/d/1s0Hiy4ZYeLLC4JWeHoqmaD9tIraxH8E7/view?usp=sharing     Data Download Link  

TIA

Vinith s  

[kentyler · Accepted solution]

Consider using a Button to go to 3 different bookmarks

https://docs.microsoft.com/en-us/power-bi/desktop-buttons
https://docs.microsoft.com/en-us/power-bi/desktop-bookmarks

I'm a personal Power Bi Trainer I learn something every time I answer a question

The Golden Rules for Power BI

1. Use a Calendar table. A custom Date tables is preferable to using the automatic date/time handling capabilities of Power BI. https://www.youtube.com/watch?v=FxiAYGbCfAQ
2. Build your data model as a Star Schema. Creating a star schema in Power BI is the best practice to improve performance and more importantly, to ensure accurate results! https://www.youtube.com/watch?v=1Kilya6aUQw
3. Use a small set up sample data when developing. When building your measures and calculated columns always use a small amount of sample data so that it will be easier to confirm that you are getting the right numbers.
4. Store all your intermediate calculations in VARs when you’re writing measures. You can return the VARs to check on your steps along the way.