Forum Discussion
Hide Visual Metrics based on Config file
Hi Arul
Thank you very much Ritaf1983 for your prompt reply. Let me share a few things here.
Here I assume that your sales sheet looks like this:
“Sales”
Based on the data you provide, I recommend that you create measures for both visual objects separately.
Measure V1 = CALCULATE( SUM('Sales'[Value]), FILTER( 'Config', 'Config'[Visual] = "V1" && 'Config'[Metric Name] = SELECTEDVALUE('Sales'[Name]) && 'Config'[Flag] <> 0 ))Measure V2 = CALCULATE( SUM('Sales'[Value]), FILTER( 'Config', 'Config'[Visual] = "V2" && 'Config'[Metric Name] = SELECTEDVALUE('Sales'[Name]) && 'Config'[Flag] <> 0 ))Here is the result.
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Arul
If I understood correctly, the table you shared has flags indicating whether a metric should be shown or hidden in each visual. To achieve your requirement, you'll need to create separate measures for each visual, using the flags in the config file to determine which metrics to display.
Since the Power BI engine doesn’t inherently know which visual it's dealing with, there’s no direct way to toggle visibility of metrics based on visuals. Instead, you can set up specific measures that check the flags for each visual and display only the relevant metrics.
For example:
1. Create a measure for Visual 1 that only includes metrics where the flag is 1 for V1.
2. Create a measure for Visual 2 that includes metrics based on the flag for V2.
Each measure will reference the appropriate flags and determine which data to display, ensuring that Visual 1 and Visual 2 show the intended metrics.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Ritaf1983 , Thank you.
Is there any way that we can do this without repetitively creating the same measures? Looking for some optimal solution.
Hi Arul
It would be difficult to do this without creating multiple measures.
I suggest you create different measures for different visuals.
If you find another way, look forward to your sharing!
Regards,
Nono Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
