Forum Discussion

abaltazar's avatar
abaltazar
New Member
4 years ago
Solved

MoM% no Month selected

I want to show the monthly change percentage on a card. But it shows me a percentage even though I haven't selected any month. Do you know where Power BI gets that percentage?

 

Need Help
  • abaltazar's avatar
    abaltazar
    4 years ago

    Thanks for your prompt reply, Greg_Deckler. I used the ISFILTERED function to show percentages only when a month is selected!

2 Replies

  • abaltazar's avatar
    abaltazar
    New Member
    4 years ago

    Thanks for your prompt reply, Greg_Deckler. I used the ISFILTERED function to show percentages only when a month is selected!

  • Greg_Deckler's avatar
    Greg_Deckler
    Icon for Community Champion rankCommunity Champion
    4 years ago

    abaltazar Not without knowing what the measure formula is. You could blank it out using HASONEVALUE for month and if you don't have one value, return BLANK.