Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Tooltip shows same table/values

Hello all,   I have a question related to tooltips and I couldn't figure it out why.   I have a table visual(let's name it 'reason table') and other page named as 'tooltip1' and when I hover on r...
Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    6 years ago

    Anonymous , if you have created a table(Calculated) and if that table is not joined with the dimension you want to filter. The table is as good as static content.

    Any table created using some calculations will not take slicer/filter values. They have to be joined back with filter/dimension tables to do so.

     

    Hope steps are correct.

    https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Anonymous , if you have created a table(Calculated) and if that table is not joined with the dimension you want to filter. The table is as good as static content.

Any table created using some calculations will not take slicer/filter values. They have to be joined back with filter/dimension tables to do so.

 

Hope steps are correct.

https://docs.microsoft.com/en-us/power-bi/desktop-tooltips

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    amitchandak I am facing a similar issue. There are 3 filters on my dashboard which I am trying to add to my measure. I am getting an error stating that the parameter is not correct type. Please guide me on this.

     

    This is my DAX

    Current Week Totals_CF =
    CALCULATE(SUM(fred_h8_banking[Amt in Bn_CF]), FILTER(ALLSELECTED(fred_h8_banking), fred_h8_banking[Week Rank_CF] = MAX(fred_h8_banking[Week Rank_CF])))
    Need to add filter for criteria 1,2 and 3 where all the filters are string.