Calculation Group with Tabular Editor

[Syndicate_Admin]

Using calculation group with Tabular Editor, when selecting the segmenter whether this volume, sales or contributions show the 3 data that correspond to CY: As current year PY: as last year and BG as Budget with its corresponding unit of measurement for example if it is contributions show me only the contributions 2021, 2022, and the respective Budget in a graph as shown above. 2021 and 2020 go in bars and the budget the line... the attached tables are an example of my model I have attached the 2 years 2021 and 2020 in a single table.

If the graph could not be made even if it is the segmentation with the 3 measures with their format of unit of measurement.

I attach link with PBIX and BD in case someone would like to help me 😞

https://drive.google.com/drive/folders/1sbxfXNHW_FIYyP3-M4E7RQofGqwsRxVA?usp=sharing

[Syndicate_Admin]

The problem is that you do not use tabular editor, to be able to change one measure with another and that has the corresponding format.

[Anonymous]

Hi @Alexgamb20,

I updated your sample pbix file(see attachment), please check whether that is what you want.

1. Update the formula of measure [BG BUdget] and [CY Current Year] as below

BG BUdget = 
VAR _seldate =
    SELECTEDVALUE ( 'Fecha'[Date] )
RETURN
    CALCULATE (
        SUM ( 'Year_BG_Key_Account'[Ventas USD] ),
        FILTER ( 'Year_BG_Key_Account', 'Year_BG_Key_Account'[Fecha] = _seldate )
    )

CY Current Year = 
VAR _seldate =
    SELECTEDVALUE ( 'Fecha'[Date] )
RETURN
    CALCULATE (
        SUM ( Anexar1[Ventas USD] ),
        FILTER ( 'Anexar1', 'Anexar1'[Fecha] = _seldate )
    )

2. Create a line and clustered column chart as below

Best Regards