Forum Discussion
Highlighting differences between tables sourced from the same DirectQuery
Hello Power BI community,
I am currently trying to solve the following:
A direct query that includes multiple fields, those relevant include [Site] and [description]. The dashboard is set up to include one table that is filtered to include only the "original" site, and the "compare" table is set up to be filtered to other locations to compare.
We need to compare the contents of the "original" site to the "compare" sites in the rest of the direct query, based on [description].
Does anybody know how to create a DAX formula that would be similar to conditional formatting in excel?
Please reply with any questions or clarification needed.
Thanks
C
Hi Anonymous ,
Which visual do you want to highlight in? Is there a relationship between the two tables? Do you use slicer to filter or filter in the filter pane?
You can use this custom visual to highlight the filtered content in many charts.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
Anonymous , For this case you need to two versions/Table of the site preferably independent
How to use independent table https://www.youtube.com/watch?v=lOEW-YUrAbE
refer how I used it for date table
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601
Hi Anonymous ,
Which visual do you want to highlight in? Is there a relationship between the two tables? Do you use slicer to filter or filter in the filter pane?
You can use this custom visual to highlight the filtered content in many charts.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
