The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
I have the following data model:
I am using the comparision across, and comparision value dimensions as filters. In this scenerio comparision across is the superset of comparision value. Sample of values are as follows:
When I add the following as slicer, only Memory is showing up in the Comparision across, and I can't select any other value.
Link to the .pbix file is as follows:
Danish
Solved! Go to Solution.
Hi @danisharoon ,
This is the expected result. Because the slicers filter each other by default, when you select "8 GB", the following row in table dim_Comparision are filtered out.
If you want to display all values in the Comparision cross slicer, change the interaction between visuals to None.
Change how visuals interact in a Power BI report
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @danisharoon ,
This is the expected result. Because the slicers filter each other by default, when you select "8 GB", the following row in table dim_Comparision are filtered out.
If you want to display all values in the Comparision cross slicer, change the interaction between visuals to None.
Change how visuals interact in a Power BI report
If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not working on my end.
Turn off single select in slicer options.
Did that for Comparision across. Issue persists
Nów clear the value slicer 🙂 The problem Here are the relationships.