Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Visual Title - Measure Doesn't Filter on Filter Selection

Hi,   I've added a measure to the Header of my Slicer. I want it to count the number of fields when not filtered, and then to adjust the value when a number of selections are made. Here are my calc...
Need Help
Show and Tell
  • Anonymous's avatar
    Anonymous
    2 years ago

    HI OwenAuger ,

     

    Thanks for looking at this. It's frustrating that Power BI doesn't allow something so simple as this.

     

    I think, to keep things simple, I'm going to group a card and filter together with the title in the card and use that. This will mean I don't need to add more rows into my data.

     

    I really appreciate you taking the time to try figure this out for me.


    Thanks,

    Mark

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
2 years ago

Hi Mark,

The limitation you've run into is that filters applied by making selections in a visual do not apply as filters to that visual itself (or any component of it), but only to other visuals.

 

In this case, the selections made in the slicer do not apply as filters for any measures evaluated as part of that same slicer visual, including title, subtitle, conditional formatting etc.

 

The same would apply to other visuals: e.g. bars selected in a bar chart cannot affect the title or formatting of the chart.

 

The simplest solution using core visuals would be to create a separate visual to display the title such as a "Card (new)" which has more alignment options than the original Card, or some other empty visual with just the title visible.

 

There could be some custom visuals out there that do provide this kind of functionality, but that would have to be part of the code behind the visual rather than working through filters and measure evaluation.

 

Regards