Forum Discussion
Using column name as filter along with condition
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
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-bookmarksI'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.
1 Reply
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-bookmarksI'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.