topic Returning Blank for Future Months in New Card Visual in DAX Commands and Tips

Returning Blank for Future Months in New Card Visual

swolfe2 — Tue, 07 Jan 2025 18:40:52 GMT

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() )

Re: Returning Blank for Future Months in New Card Visual

Jihwan_Kim — Wed, 08 Jan 2025 03:34:45 GMT

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

Re: Returning Blank for Future Months in New Card Visual

swolfe2 — Wed, 08 Jan 2025 12:24:38 GMT

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.

Re: Returning Blank for Future Months in New Card Visual

Anonymous — Tue, 14 Jan 2025 02:32:24 GMT

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