The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have two different card visuals that show an average score field. One is filterable by slicers for a few columns that effect this score, the other is not effected by these slicers. I want to create a 3rd card visual that shows the difference between these two visuals. So users can quickly see the impacts on the score due to the other columns through the slicers.
Any Idea how I could do this or if it is feasible within BI?
Hello @trevordunham ,
can you provide a sample data and show us your scenario so we could help.
Proud to be a Super User! | |
Hi @Idrissshatila,
Seems like I am not able to upload a sample pbix or excel file to show the issue. Here is kind of how the data looks:
Score | Category | Product |
21 | A | 3 |
70 | B | 2 |
66 | C | 2 |
76 | A | 3 |
7 | C | 2 |
91 | B | 1 |
71 | c | 2 |
10 | c | 1 |
34 | a | 3 |
84 | a | 3 |
18 | b | 3 |
81 | b | 2 |
27 | a | 2 |
58 | b | 3 |
23 | v | 1 |
79 | a | 2 |
35 | s | 2 |
54 | r | 1 |
39 | v | 3 |
74 | r | 3 |
20 | r | 2 |
81 | v | 3 |
Hello @trevordunham ,
I prepaired you a pbix file with a sample of what you want.
Proud to be a Super User! | |
This overall works but I do have some other columns that I want to work as filters still such as date. How do I change the unfiltered measure to include other filters? I really just want the two columns here to be unfiltered but every other filter to remain the same.