Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello Everyone,
I am super green to Power Bi (I know DA and SQL to a decent degree) and I am trying to build a report that provides a high level overview (left table), then breaks down the aggregate on the right table.
Below is the DAX query I used to make both the Completed Consents and Incomplete Consents column
Completed Consents = CALCULATE(COUNTROWS(FILTER(ltit_userconsent,ltit_userconsent[Consent Status] ="Complete")))
Incomplete Consents = CALCULATE(COUNTROWS(FILTER(ltit_userconsent,ltit_userconsent[Consent Status] ="Incomplete")))
The right table filters properly depending on if you click Policy Name, Department. What would be the best approcate to make it so when you click either completed consent or incomplete consent on the left table the right table filters to show the resepective selection of the document & department and then selected filter for consent status (complete / incomplete) .
Hi @Tyker504
Are you not wanting to filter the right table when you click on the left table? If I understand correctly, you can try the following:
1. select the left table first. Then select Format -> Edit interactions
2. select "None" in the upper right corner of the right table
Output:
Best Regards,
Yulia Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not quite. The left table is the main table that breaks down all policies with their completed %. When a use clicks into completed Consents or Incomplete Consents on the left hand side the right hand side filters down to show only the respective (incomplete / complete) status on the right.
Clicking Left square will filter the right table to show those two squares.
but the tip you did provide above will help with that issue 😀
Hi @Tyker504
Could you please provide me with more sample data so that I can better help you? How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.
Best Regards,
Yulia Xu
User | Count |
---|---|
22 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
26 | |
13 | |
11 | |
9 | |
6 |