It is possible to hide the column (measured/calculated) for the first year of comparison?

[TomasGazsi]

Hi, 

first of all, I am a beginner in Power Bi. Therefore I apologize if this is a simple question. 

I need compare 2023y. with 2024y. So I use metrix:

I need only green rectangle. Year 2023 is first year of measured. 

Properties of metrix. Date is CALENDAR() table with releationship to main table:

Calculated column Mezirocni rozdil v % - DAX syntax:

pocitany_medzirocny_rozdiel_v_percentach =

IF(

    ISFILTERED('Tabl_kalendar'[Date]),

    ERROR("Rychlou míru časového měřítka je možné seskupovat nebo filtrovat jenom pomocí hierarchie data poskytnuté službou Power BI nebo primárního sloupce dat."),

    VAR __PREV_YEAR =

        CALCULATE(

            [pocitany_CelkemBezDPH],

            DATEADD('Tabl_kalendar'[Date].[Date], -1, YEAR)

        )

    RETURN

        DIVIDE([pocitany_CelkemBezDPH] - __PREV_YEAR, __PREV_YEAR)

)

Is possible to hide (red) column in metrix? Or it is not possible? Or is there some workaround solution? 

Thanks for any advice. 

[Anonymous · Accepted solution]

Hi @TomasGazsi 

Unfortunately, there is no such an visibility option that supports to conditionally hide/show column in Matrix. You can conditionally control whether or not the value is displayed by writing a measure, but even then the column will still be there.
Reference post : Solved: How can i hide Column ? - Microsoft Fabric Community

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[TomasGazsi]

Hi, 

thank you for your response. I assumed that it is as you write.