Returning Blank for Future Months in New Card Visual

[swolfe2]

I have a table, V_PBI_MONTH_MASTER, which has 12 rows; one for each month.
Each month, a process will update this table's CLOSED_MONTH field to change it from "NO" to "YES".
I have already created a new card visual with V_PBI_MONTH_MASTER.MONTH_SHORT_NAME in it, and have a DAX calculation which appears to be working as expected. However, there is no option within the new card visual for "items with no data".

The requirements from the business are to display the new card visual with headers for each month, but only a value under them if the CLOSED_MONTH = "YES". This way, the displayed values will automatically be presented once available.

I have also tried this with conditional formatting, returning 999999999 instead of BLANK() since it's not a value that would appear natively. However, the conditional formatting rules within the new card visual format every value the exact same whether it's true or not. I'm not quite sure why this would be happening.

Cost Actuals vs Plan By Month =
VAR ClosedMonth = SELECTEDVALUE(V_PBI_MONTH_MASTER[CLOSED_MONTH])
RETURN
    IF(
        ClosedMonth = "YES",
        [Cost Actuals vs Plan],
        BLANK()
    )

[Anonymous]

Hi @swolfe2 ,

As mentioned in the post below: It should be solved in the next releases of Power BI.
Solved: Conditional Formatting - New Card Visual - Ref Lab... - Microsoft Fabric Community

If you want to follow up on the progress of the fix as soon as possible. You can create a support ticket and a dedicated Microsoft engineer will come to solve the problem for you.

It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support:  https://powerbi.microsoft.com/en-us/support/

For how to create a support ticket, please refer to  How to create a support ticket in Power BI - Microsoft Fabric Community

Best Regards,

Stephen Tao

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please try something like below whether it suits your requirement.

Show items with no data in Power BI - Power BI | Microsoft Learn

[swolfe2]

This isn't quite the solve, as it's showing (Blank) in columns that do not have values. I want it to "display" nothing by hiding the text and making it the same color as the background in conditional formatting. What happens when you try to conditionally format in the New Card visual is that it actually formats ALL the values, not just the ones that meet the rule.