Issue in Dynamic Formatting

Hi Karthi_0502 ,

The issue you're experiencing stems from the use of SELECTEDMEASURE( ) within a FORMAT( ) function, combined with the SWITCH( ) logic. Power BI can apply formatting inconsistently when the measure's context changes, especially across months or with slicers.

Create two separate measures—one for display and one for calculations—to handle formatting dynamically but more reliably.

Step 1: Base Calculation Measure

Dynamic_Collection = 
SWITCH(
    TRUE(),
    SELECTEDVALUE('Total/Count'[Column1]) = "$ Value", [Total],
    SELECTEDVALUE('Total/Count'[Column1]) = "Voucher", [Count],
    BLANK()
)

Step 2: Corrected Dynamic Formatting

Formatted_Value = 
VAR typevalue = SELECTEDVALUE('Total/Count'[Column1])
VAR measureValue = [Dynamic_Collection]  -- Use the calculated measure directly

RETURN
    SWITCH(
        TRUE(),
        typevalue = "Total" && measureValue < 1000, FORMAT(measureValue, "$#,##0"),
        typevalue = "Total" && measureValue >= 1000 && measureValue < 1000000, FORMAT(measureValue / 1000, "$#,##0K"),
        typevalue = "Total" && measureValue >= 1000000, FORMAT(measureValue / 1000000, "$#,##0M"),
        typevalue = "Count", FORMAT(measureValue, "0"),
        FORMAT(measureValue, "0")
    )

• Refresh visuals after changes.
• Ensure the slicer correctly filters data by testing each selection independently.
• Use table visuals to validate numeric values before applying pie charts or other visuals.

Please mark this post as solution if it helps you. Appreciate Kudos.