Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi all!
I'm struggling with the following. I attached an image for better understanding
I need to create a chart that plots a different measure based on selection. I know how to do that. The problem comes into play when I want to chart this measure comparing two same sets of slicers (I have 6 dimensions i need to use per each comparable).
I have come to two possible solutions but they are not as clean as desired. One is overlapping two charts showng the same measure but adapting interactions between slicers and charts. The sencond one would be duplicating all dimensions tables/columns and duplicating all measures to use the ALLSELECTED function to adapt each measure to each set dimensions, but that would be messy.
Any idea on how to make it?
Thanks!
Thanks for the reply @amitchandak .
Nevertheless My data is huge and duplicating tables or dimensions is not possible from a data model and data size point of view.
Thanks anyway!
@XTF , My two video can help
Compare two Brands: https://youtu.be/exN4nTewgbc
How to use two Date/Period slicers
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
11 | |
10 | |
10 | |
9 |
User | Count |
---|---|
18 | |
13 | |
12 | |
11 | |
8 |