Forum Discussion

Atanas_Atanasov's avatar
Atanas_Atanasov
Icon for Helper II rankHelper II
7 months ago
Solved

Conditional Formatting Based On Multiple Crieria (sorry I searched, but couldn't find solution)

Dear community, I have a simple table loaded in power BI which looks like that (screenshot 1)   The metric column and the quarter columns are coming from a single table named "Quarterly Resu...
  • Praful_Potphode's avatar
    Praful_Potphode
    7 months ago

    Hi Atanas_Atanasov ,

    You can use Visual Calculation(Select Your Visual and click on New Visual Calculation) to achieve the result shown below:

    PFA PBIX.

    Please give Kudos or mark it as solution once confirmed.

     

    Thanks and Regards,

    Praful

     

Atanas_Atanasov's avatar
Atanas_Atanasov
Icon for Helper II rankHelper II
7 months ago

divyed and Praful_Potphode - also I was able to do it with DAX today... there was sorting happening in the table. The metrics column was sorted by another column, so the order appears the same every time. So, basically:
CALCULATE(
    [Volumes],
    REMOVEFILTERS( Quarterly Volumes[Order] ),
    Quartertly Volumes[Metric] = "BF Surveyable Events"
) works like a charm now... I know it is a trivial problem, but really was not aware of it.
Biggest takeaway is if your DAX is not working as it should be always check that... mainly in calendar tables. 
Thank you both,
Atanas