Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
 View Only
  • 1.  Working with datetable based on condition

    Bronze Contributor
    Posted Apr 13, 2022 06:42 AM
    I have a data like this

    I want to show icons on table based on the dates. so up to 24th may 2022 I want to show yellow color icon and whenever the day is 25th may 2022 then I want to show green color icon and if date pass then I want to show red color icon. How to do this in power bi


    ------------------------------
    Phaneendra Adusumilli
    ------------------------------


  • 2.  RE: Working with datetable based on condition

    Top Contributor
    Posted Apr 13, 2022 10:05 PM
    Need a little more context.  Is May 25th in the future or the current hypothetical date?  What is special about the 25th?

    ------------------------------
    Brian Connelly
    Manager Business Analytics and Insights
    Ashfield Healthcare
    ------------------------------



  • 3.  RE: Working with datetable based on condition

    Posted Apr 14, 2022 01:09 PM

    Hi Phaneedra,

    Why you need 25th May? Hard to belive you want put icons on STATIC day. In June they will still show you purple for 24th and green for 26th. Make no sense to me.
    What is logic behind this?
    Otherwise just take a red/amber/green pen and color your screen. Efect will be the same.

    Regards.



    ------------------------------
    Adam Artur Boltryk
    Business Analyst
    ------------------------------