Using column name as filter along with condition

Anonymous — Fri, 03 Jan 2020 07:29:34 GMT

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

Re: Using column name as filter along with condition

kentyler — Sat, 04 Jan 2020 04:28:48 GMT

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

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
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
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.
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.

topic Re: Using column name as filter along with condition in Developer

Using column name as filter along with condition

Re: Using column name as filter along with condition