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.
Hi,
I have a requirement to create a table visual showing different amount columns/fields( charges, payments and adjustments) based on different categorical fields/columns like department, location etc. The amount are single select and multiselect, if no amount is selected then the tableshouldnt appear.
Is there any way to achieve this using custom visuals from appstore?
Solved! Go to Solution.
HI @Anonymous,
#1, You can do unpivot column on your value fields to convert them to attribute and value, then you can use the attribute field on slicer to accurately control what type of value fields display on your visual.
Dynamic Attributes In A Power BI Report
#2, Currently, you cannot directly use a filter to control the visibility of visuals. (you can filter on it to show blank visual contents but can't hide it)
Perhaps you can take a look at the following blog to create a card visual to mask the raw visual based on selection:
Show or Hide a Power BI Visual Based on Selection
BTW, you can also create a script-based visual to plot your graph, it can be process based on its script and conditions. (these type of visual can't interact with other visual but they can receive the filter/interact from other visuals)
Regards,
Xiaoxin Sheng
HI @Anonymous,
#1, You can do unpivot column on your value fields to convert them to attribute and value, then you can use the attribute field on slicer to accurately control what type of value fields display on your visual.
Dynamic Attributes In A Power BI Report
#2, Currently, you cannot directly use a filter to control the visibility of visuals. (you can filter on it to show blank visual contents but can't hide it)
Perhaps you can take a look at the following blog to create a card visual to mask the raw visual based on selection:
Show or Hide a Power BI Visual Based on Selection
BTW, you can also create a script-based visual to plot your graph, it can be process based on its script and conditions. (these type of visual can't interact with other visual but they can receive the filter/interact from other visuals)
Regards,
Xiaoxin Sheng
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 |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |