Forum Discussion

LearningHub_KD's avatar
LearningHub_KD
New Member
1 year ago

Help with Power BI Metrics

Only Growth % should be shown in year where prvs year is available in this case 2023 wouldn't have any comparisons,

similarly for forecast which will only be shown in future years 2025, 2026 not in 2023 and 2024 which current and prvs year

 

How can I achived this in Power BI metrcis ?

Data and and Desired results are in SS

 

Need Help

5 Replies

  • LearningHub_KD's avatar
    LearningHub_KD
    New Member
    1 year ago
    CityYearOperating ExpenseActual SalesPlan Sales
    A2023259702609
    A2024288735604
    A2025233587607
    A2026212688597
    A2023201645729
    A2024224711652
    A2025319594652
    A2026285679631
    A2023256664550
    A2024286592589
    A2025208597570
    A2026330595563
    A2023269643716
    A2024200659614
    A2025281736574
    A2026235576704
    B2023224626691
    B2024224636741
    B2025267717625
    B2026326699636
    B2023260733680
    B2024280661743
    B2025201669555
    B2026292721554
    B2023221562611
    B2024250640736
    B2025293660630
    B2026302730587
    B2023221555565
    B2024244587612
    B2025322641693
    B2026238641552

    Hi ,

    Will this work

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi LearningHub_KD ,

     

    Try turning off text wrapping and auto-size width, and then manually drag and drop the width of the column to hide the unwanted columns:

    Here's an example file.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum