Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Problem showing percentage evolution in histogram bars

Hello, I have a table with 2 rows : accounts numbers plus date of contact. I added a computed column with YEAR(DateContact). I've made a visual report (grouped histogram) with the Year as axis, and...
dedelman_clng's avatar
dedelman_clng
Icon for Community Champion rankCommunity Champion
5 years ago

Hi Anonymous -

 

Is this what you're looking for?

 

YoY Evolution =
VAR __ThisYr =
    SELECTEDVALUE ( Accounts[Year of Contact] )
RETURN
    DIVIDE (
        COUNT ( Accounts[Acct Number] ),
        CALCULATE (
            COUNT ( Accounts[Acct Number] ),
            Accounts[Year of Contact] = __ThisYr - 1
        )
    )

 

If not, please provide sample data and expected results, or a sample pbix file with sensitive data removed.

 

Hope this helps

David