Forum Discussion
Filtering Chart Based On One Dimension Independently From Others
Hello.
I am looking for help with the following case. I have a table that has ProjektNr, Month*, Billing Value, Revenue Value, Etc.
Below this table, I have a line chart that is showing these Billing Values, Revenue Values across the specific timeline.
Action:
What I want to do is to select one ProjektNr from the table and have the line chart filtered with Billing Value, Revenue Value of this specific project across the timeline. I would like to have this line chart filter dependent on the ProjektNr but independent from the period (month).
Challenge:
When I click on the ProjektNr from the table, my line chart is filtering also the month that I have included in the table.
*My table is filtered with the "highest" period (i.e. most recent period). I guess that this can be the issue...
Anonymous ,
Have you tried dax function like pattern below?
Result = IF ( HASONEVALUE ( Table[Column] ), IF ( SELECTEDVALUE ( Table[Column] ) = "a", condition1, condition2 ) )Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
v-yuta-msftCommunity Support
Anonymous ,
Generally, you may try "Edit Interaction" to disable the interaction between visuals. You can refer to doc below:
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
thanks for the response. you are right, but if I edit interactions and disable relation between these two visuals if I click any of the project nr from the table above, the line chart on the bottom will remain unchanged (whereas I want the line chart to reflect the trending for this particular project that I select from the table above).
Do you have any other idea?
- v-yuta-msft
Anonymous ,
Have you tried dax function like pattern below?
Result = IF ( HASONEVALUE ( Table[Column] ), IF ( SELECTEDVALUE ( Table[Column] ) = "a", condition1, condition2 ) )Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.