The reason is that the matrices, like most Power BI visuals, hide rows if the measure they are showing produces a blank. Yet, the Color slicer is still showing all the colors, even though we know Amanda only purchased three colors: Grey, Silver and White. The noticeable thing about the behavior of the slicer is that the two matrices are showing only the brands and colors purchased by Amanda. In the customer slicer, Amanda Allen is selected. In the following report, one slicer is filtering the customers by name, another slicer is showing colors and two matrices are showing sales amount by brand and by color. Let us see how this feature works and why it is so relevant. There is a feature in the June 2019 update of Power BI that greatly mitigates the need for bidirectional cross-filters: we can apply visual filters to slicers, so it is possible to filter slicers by using a measure. You can find a description of risks and best practices in the Understanding Relationships in Power BI video and the Bidirectional relationships and ambiguity in DAX article. One feature that is often misused is the bidirectional cross-filter in relationships. Sometimes, this power is used without considering its possible side effects. Data modeling capabilities in Power BI are very powerful.
0 kommentar(er)
