Forum Discussion

marcofalzone's avatar
marcofalzone
Helper I
3 years ago
Solved

Conditional Formatting with Calculation Groups - Issues, please help me

Hi community, I developed a model with some conditional formatting, and I'm quite happy with it.

Since the number of measures is quickly growing, I've started to implement Calculation Groups, to make it more efficient, and the model actually works fine with calculation groups implemented. Despite that, I found some issues with a simple conditional formatting configuration.

 

Download - Sample Model (300 kb):

https://www.dropbox.com/scl/fi/4sju5841r4m3afq7tewdo/Help_CalcGroups.zip?rlkey=v65nx5eshluxkz310ta7jacxe&dl=0

 

My basic conditional formatted visual without calculation groups looks as follows, and works just fine.

 

 

The formatting condition is pretty simple and based on one field.

The background of the rows of the table 'PL_Structure' is light blue where the field 'PL_Structure' [PL_Detail] has value 0 (running total rows), while are colored in light grey where the field value is 2 (subtotal row). The other - common rows - stay white (default color).

The structure of the table can be found in the attachment together with the model (DataSource.xlsx), and includes an explanation of key fields as well.

 

 

My formatting conditions

The "PL SubTot Color" measure simply reads the SELECTEDVALUE of the above mentioned [PL_Detail] field):

 

Now, with calculation groups implemented, I'm experimenting a strange behaviour, the numbers are just ok, but the table looks as follows:

 

 

Maybe I did not fully understand the logics behind calculation groups, but I find them extremely useful for maintenance purposes.

The attached model includes a side by side (with / without calculation groups).

 

I do appreciate any suggestion or fix. Thank you.

Marco 

 

 

 

  • I found the solution by myself. If somebody is interested, let me know, to post it.

    Thanks anyway to all.

    Marco

7 Replies

  • I found the solution by myself. If somebody is interested, let me know, to post it.

    Thanks anyway to all.

    Marco

    • mora11's avatar
      mora11
      Helper I

      Can you please share? I have same problem. Thanks

  • shinym201290's avatar
    shinym201290
    Frequent Visitor

    hi marcofalzone -
    I am also looking for a similar solution where I can do formatting for particular groups at row level in a matrix using calculation groups.
    It would be great if you can post the solution or links that can help

    • marcofalzone's avatar
      marcofalzone
      Helper I

      Sure, let me know if you prefer to send me a sample of your dataset (real case), or as alternative, I can give a generic example based on my experience. 

      • shinym201290's avatar
        shinym201290
        Frequent Visitor

        marcofalzone - Thanks for the quick response!
        I have calculation group with two items Sales and Quantity.
        I would like to apply background color only on Sales column and for the Category - Bikes
        Sample File