Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i am creating a filter table based on selected year of dimension table , but table is not returning any row for selected year. If i use static value of selected year i.e. 2019 then table returns rows so please help why dynamic year is not working.
Below is my code
Solved! Go to Solution.
Hi @shyamji ,
We cannot create dymanic calculated column in power bi. I suggest your to create relationship between table based on year columns and use table visual to work around.
Hi @shyamji ,
We cannot create dymanic calculated column in power bi. I suggest your to create relationship between table based on year columns and use table visual to work around.
Not 100% clear on this. Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
But, if you are trying to create an actual table in the model based upon a slicer selection that is simply not possible. Tables in the data model are calculated at refresh, they are not dynamic based upon dynamic user interaction. You can use a measure that includes a table VAR and that can be dynamic within the measure calculation.
Bottom line, I'm not clear on what you are asking.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.