Forum Discussion
Filter on Filter
Well, I would probably want to look at this but the description is not clear to me at all. On top of that, may I ask why you're having bi-dir filters everywhere? This is AGAINST Best Practices of data modeling in PBI.
Please refer to this first: How to Get Your Question Answered Quickly - Microsoft Power BI Community
Hi daxer, I appreciate your response. The reason why I have bidirectional connection was bc the dim_export performances table contains the budget values and the columns value kept repeating itself in the visuals for various phases and activity rows. I am open to your suggestion on how to properly link the tables. This is one of my weak spot. What I was hoping to accomplish is to have the dim/fact_Fcst Unit Adj table act as a forecast input sheet whereby users will input Unit_Adj value by month in the Excel file and the visuals would calculate Hrs_to_Comp and Total Proj Hrs field in the visuals using the input from the Unit_Adj field based on a month slicer selection (Unit Adj. Fcst Date). Keep in mind that each project can have the same phase and activity but when concatenated (project/phase/activity) it becomes a unqiue key field. This is the reason why I am concatenating those 3 fields so that I have a key field. The Period slicer should be independent from the Unit Adj. Fcst Date slicer as the Period slicer is used to control the bugeted and actual hours and qty while the Unit Adj. Fcst Date slicer is used to calculate the Hrs_to_Comp and Total Proj Hrs measure calculation field. The pbi file and screenshots are listed below for your reference. Appreciate any help or suggestion you can provide. I look forward to your reply. Thanks!