Forum Discussion
Power Bi
Hello All,
I am facing one issue when I am creating report If any know solution for my Query Kindly help me.
In bar graph varience is grouping by Project and Quarter. If I drillthorw on any bar in that graph It filtering Transactions of perticular project in that quarter.
I have data like below.
| Quarter | Project name | Transaction ID | Variance | Part No |
| Q1 23 | A | 1 | $123 | P1 |
| Q1 23 | B | 2 | $213 | P2 |
| Q1 22 | C | 3 | $74 | P3 |
| Q2 23 | D | 4 | $543 | P4 |
| Q2 22 | A | 5 | $56 | P5 |
| Q2 23 | E | 6 | $231 | p6 |
if I apply drill throw on Project name "B" It should show below values.
| Quarter | Project name | Transaction Id | Variance | Part No |
| Q1 23 | A | 1 | $123 | P1 |
| Q1 23 | B | 2 | $213 | P2 |
| Q1 22 | C | 3 | $74 | P3 |
It should filter selected quarter. How can I get this. If any can help with this That will be very help ful.
Thanks in Advance.
1 Reply
ManeeshaYmona You should modify your Data for Grouping .THANK YOU!!
