Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Data shown repetetive

Hi,
I am fairly new to pbi and have a quick question. As you can see it shows the percentage for each year. 
The measure I have calculated is only for 2021, so i do not understand why the year 2020 and 2019 are even showing. I have a filter for so only data starting from 1.06.2020 is selected. 

Pls someone tell me how I get rid of 2019 + 2020 in this visualization (I only want 2021 to show).

 

thanks

 

Need Help
  • m3tr01d's avatar
    m3tr01d
    5 years ago

    You could also simply go in the visual filter and remove the year

    But if you only show one year on the chart, maybe you could use a Card visual instead

     

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , If you have use a measure like this

     

    Calculate(sum(Table[Value]), Table[Year] =2021)

     

    Then change it to

     

    Calculate(sum(Table[Value]), filter(Table,Table[Year] =2021))

     

    or

    Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      this is how i calculated the measure im trying to display 

       

      TSP_br for 2021 % difference from TSP_br for 2020 =
      VAR __BASELINE_VALUE = [TSP_br for 2020]
      VAR __VALUE_TO_COMPARE = [TSP_br for 2021]
      RETURN
      IF(
      NOT ISBLANK(__VALUE_TO_COMPARE),
      DIVIDE(__VALUE_TO_COMPARE - __BASELINE_VALUE, __BASELINE_VALUE)
      )
       
      I have a quick measure for TSP_br for 2020 and TSP_br for 2021
       
      thanks for your help
      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        my co-worker once showed me how to remove something like in the problem I am facing (there is an option to remove it somwhere), it just dont remember how she did it