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.
I have two tables. Project (ProjectID, ProjectName) and ProjectAssignments (EmployeName, ProjectID, Role).
I have binded all the project into Slicer and converted into the Dropdown. And I have binded all the project assignments to the grid.
So now when I select any project from the dropdown slicer, it filters the Project Assignment table automatically as I have already defined relationship between this two models.
But now I have added a calculated Meaure column to the ProjectAssignmnt model and added that measure column to the Project Assignment grid, and when I do that it stopped the default filters of ProjectAssignment.
So adding calculated Measure column stopped my default filtering option.
Is here any way so that I can come to know how can I overcome this?
Solved! Go to Solution.
What are the conditions for the conditional formatting?
Regarding the measure, does [MeasureCount] work better?
Is it possible to share your pbix?
@aakashdmorya - What is the behavior? What is the desired behavior? What is the measure expression?
Thanks,
Nathan
@Anonymous
I have added few conditional formatting on the dates columns. Please find the image below
When I select a project from slicer, this grid does not filter by selected project, instead, it remove all the conditional formatting. See in image.
M. is my measure column and it has value :
What are the conditions for the conditional formatting?
Regarding the measure, does [MeasureCount] work better?
Is it possible to share your pbix?
Thanks for the reply,
but the report consist of too many data and lots of model into it.
So providing pbix will be not secure for me.
Thing which you can suggest me is, filtering a table visual which have a Measure column in it.
Because if I remove the measure column from the grid, it start working fine.
If you have values that are directly filtered by another related table, then it will be filtered automatically. What table are all of the columns coming from? And what is the expression of the other measure?
Thanks allot @Anonymous for being with me on this topic. I appreciate your time and curiosity to get it solved.
I figured out that the problem was with my measure. I converted the Measure to Column type and then it worked.
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.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
60 |
User | Count |
---|---|
150 | |
115 | |
104 | |
89 | |
65 |