Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Is there any way I can get the displayed data on the card visual?
My problem is I have two card visuals. I cannot use a multi row card as the two cards are acted upon by different slicers (some don't interact with one visual). So, though the underlying data is the same, the visuals show data based on different criteria and hence cannot be on the same visual.
I am trying to get the % difference between the displayed data in the two cards. Any help is appreciated
-Prasad
@pvenkat ,
Could you please share some sample data and clarify more details about your requirement?
Regards,
Jimmy Tao
Here is a test data set for what I am trying to build with:
Date | Route Time | Clean Time | Clean Time - Route Time | Inspection Time | Inspect - Clean Time | Vert Surfaces | Horiz Surfaces | Final Scores | |
3/16/2020 | 9:00 | 9:01 | 1 | 9:15 | 14 | 1 | 1 | 1.0 | |
3/23/2020 | 9:00 | 9:05 | 5 | 11:16 | 131 | 4 | 5 | 4.7 | |
3/30/2020 | 9:00 | 9:20 | 20 | 10:00 | 40 | 1 | 3 | 1.8 | |
4/6/2020 | 9:00 | 8:50 | 9 | 11:16 | 146 | 4 | 5 | 4.7 | |
4/13/2020 | 2:00 | 2:18 | 18 | 2:45 | 27 | 1 | 2 | 1.3 | |
4/20/2020 | 2:00 | 2:40 | 40 | 4:20 | 100 | 3 | 5 | 4.0 |
@pvenkat ,
You should disable Slicer3 in the first card visual and disable Slicer2 and Slicer3 in the second card visual. For details, please refer to doc below:
https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Jimmy,
The edit interactive features of the slicers was already done. My challenge is to get the % of the data that is now shown in the card visuals.
Regards,
Prasad
@pvenkat ,
Could you share the dax expression of S1 and S2 so I could do further analysis?
Regards,
Jimmy Tao
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
93 | |
75 | |
62 | |
50 |
User | Count |
---|---|
147 | |
107 | |
105 | |
87 | |
61 |