Forum Discussion

hidenseek9's avatar
hidenseek9
Icon for Post Patron rankPost Patron
9 years ago
Solved

Want to disable automatic filtering on visuals

Hello Power BI Community!

 

I have a problem with filtering.

What I want to do to have a chart like below showing a trend of

Sales and expense and have a dynamic timeline to adjust the dates on the chart.

BUT I want to show an expense percentage of sales for 2015/2016 on a card

unaffected by timeline visuals.

 

So what I have in below photo is that in 2015, the company had 1.6% of expense in comparison to 2015 sales.

If I choose to select just 2016 in a dynamic timeline visual, I still want the card to show 1.6% for 2015.

 

Is it possible? If so how?

 

I am calculating Sales, Expense and % with a measure.

Sales = calculate(sum(sales))

Expense = calculate(sum(expense))

% = divide(sum(expense),Sales,0)

I am using "Visual level filter" to filter the dates in 2015 to calculate the % for 2015.

 

I think I should be able to calculate 2015 Sales and Expense using a filter function in a measure,

but could not figure out how to do it.

 

Many thanks,

 

H

 

 

 

  • Anonymous's avatar
    Anonymous
    9 years ago

    hidenseek9,

    You can use the "Edit interactions" feature in Power BI Desktop.

    Click on the timeline visual in your scenario, turn on "Edit interactions" under Format ribbon, then choose "None" in the Card visual, this way, you will get expected result.


    Regards,

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    hidenseek9,

    You can use the "Edit interactions" feature in Power BI Desktop.

    Click on the timeline visual in your scenario, turn on "Edit interactions" under Format ribbon, then choose "None" in the Card visual, this way, you will get expected result.


    Regards,

    • hidenseek9's avatar
      hidenseek9
      Icon for Post Patron rankPost Patron

      Anonymous

       

      Thank you for your advice!

      It is working perfectly.

       

      Many thanks,

       

      H

    • JimT99's avatar
      JimT99
      Icon for Helper I rankHelper I

      I tried this with a card and it didn't work.  When I click on the card it filtersr the rest of the visuals 

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hello,

    in case I have heaps of visuals and wan to disable them all at once. Is there a way to do so or do I have to click on all of them?

    Thanks