Forum Discussion

petar_kisdobran's avatar
petar_kisdobran
Frequent Visitor
3 years ago
Solved

Table with predefined form with multiple measures in columns

Hi everyone,   Can I kindly ask you to help me with following challenge, i have two tables, one with actual data and other with budgeted. I appended them to have data in one query, and tried with ...
Need Help
Ahmedx's avatar
Ahmedx
Super User
3 years ago

You can add any character and apply conditional formatting to its font color. for example make it transparent

CF = IF(SELECTEDVALUE(DimLine[Line])=UNICHAR(152),"#3E4AFF00")
  • petar_kisdobran's avatar
    petar_kisdobran
    Frequent Visitor
    3 years ago

    sorry for torturing this much, if I would like to add transparency format to your code line unichar (bottom of the actuals measure code)

    ....

      "", "",
        UNICHAR ( 160 ), "",
        FORMAT ([Act],"#")
    )
     
    and to change it for instance to Unichar (130),"", is it possible to add an transparency format to that line ?
    eg
    ....
    format (unichar130),#3E4AFF00",
    FORMAT ([Act],"#")
    )
     
    Thank you so much for all!
     
    My best,
    Petar