Need to have date column in report but export should not display its value

[srlabhe]

Hi 

I have a date column AsOfDate in report which is being used to derive flag which is used to filter on Table visual.

Now I dont want that column in report but if I take that AsOfDAte from table visual it changes data , I mean no of records changes.

While If I have that AsOfDAte in visual the no of records are fine.

Now I want this column to be part of visual but while exporting it should show blank value

I have tried changing text and header to white as it works fine only in PBI but not in export(shows dates in that column in export)

Any suggestions here please 

[v-venuppu]

Hi @srlabhe ,

I hope the information provided is helpful.I wanted to check whether you were able to resolve the issue with the provided solutions.Please let us know if you need any further assistance.

Thank you.

[v-venuppu]

Hi @srlabhe ,

May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.

Thank you.

[v-venuppu]

Hi @srlabhe ,

I wanted to check if you had the opportunity to review the information provided and resolve the issue..?Please let us know if you need any further assistance.We are happy to help.

Thank you.

[v-venuppu · Accepted solution]

Hi @srlabhe ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @GeraldGEmerick @FritsOrdelman for the prompt response.

I have tried replicating the scenario using sample data.Please go through the attached PBIX for your reference.

[FritsOrdelman]

You can create a new column that returns blank values, and use that in the visual instead of the actual AsOfDate. Here's how:

AsOfDate_Export = BLANK()

Then:

• Use the original AsOfDate for filtering logic.
• Use AsOfDate_Export in the table visual.

This way, the column remains in the visual (so filtering works), but it will show blank values both in Power BI and in the exported file.

Hope it will help

[srlabhe]

As I mentioned there is Measure Flag calculated based on values on As_Of_Date column, hence need to have that column as original value. I am fine even to take that column off, but when I do same, it just chnages the no of records in table visual.

[GeraldGEmerick]

@srlabhe Perhaps if you could provide sample data we can mock this up and see what options there are.

[GeraldGEmerick]

@srlabhe Perhaps you could instead put that column in the Filters pane to restrict the number of records in the table visual?