Forum Discussion
Only One Dashboard Being Filtered
Hi,
I created a relationship using keys for different data as shown
Without any filter the dashboards are ok as shown
But when I used GRV_Creditors as the main filters the other dashbboards won't follow as shown
Any comments what I'm doing wrong
//NT
HI,Anonymous
Regarding the issue you raised, my solution is as follows:
1.create relationships between tables:
2. Below are the measure I've created for your needs:
Sum of Project = VAR year1=VALUES('GRV_CreditorPurchaseInvoice_PRO'[Year]) RETURN IF(ISFILTERED('GRV_CreditorPurchaseInvoice_PRO'[Year]), CALCULATE(COUNT('gbkmut_pro'[Project]),'gbkmut_pro'[Year] IN year1),COUNT('gbkmut_pro'[Project]))Sum of sale = VAR year1=VALUES('GRV_CreditorPurchaseInvoice_PRO'[Year]) RETURN IF(ISFILTERED('GRV_CreditorPurchaseInvoice_PRO'[Year]), CALCULATE(SUM('GRV_DebtorSalesInvoices_PRO'[Invoice Amount]),'GRV_DebtorSalesInvoices_PRO'[Year] IN year1),SUM(GRV_DebtorSalesInvoices_PRO[Invoice Amount]))3.Modify visual Settings:
4.Here's my final result, which I hope meets your requirements.
Please find the attached pbix relevant to the case.
Best Regards,
Leroy Lu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
14 Replies
rubayatyasminCommunity Champion
Hi, Anonymous
can you please check interaction between visuals is turned on?
Also, is it possible to make your data model slightly cleaner?
- elitesmitpatel
Solution Supplier
it activate when you select the visual and then go to format -> edit interactions
andwe have to look at all the visual for solution
please share the file if possible
- elitesmitpatel
need to check measure and relationship first.Please share the file Anonymous , it will be helpful for the community
- rubayatyasmin
With the current settings you can not upload the file. Best thing is you can go to file.io and upload your file. Then share the link here.
