Exporting Selected Columns from Power BI Table Chart with Field Parameters

Tailored CSV Export in Power BI – No More Unwanted Columns!

Hello everyone, 

In this article I'll walkthorugh super helpful post for anyone wanting more control over what they export from Power BI. Let's jump into topic. 

This is my  Uber Rides Performance Report based on sample data. The Table visual displays a detailed analysis of ride performance using key KPIs.

Normally, if you want to export data, you can do so using the Export Data option (1) found under the ellipsis (⋯) on the visual.

However, my requirement is slightly different:

I don’t want to export all columns shown in the table visual. Instead, I want to export only selected columns. For example, I need only Date, Location, Description, Total Revenue, Total Fare, Total Distance (Km) Let’s Walk through how to achieve this.

Let’s walk through how to achieve this.

Step 1: Create a Field Parameter for Attributes

Navigate to the Modelling tab (2). Click the New Parameter dropdown (3), and choose Fields (4).

In the Fields Parameters window that opens:

• Drag the desired attribute fields from the Fields pane (5) into the Add and reorder fields area (6).
• Give the parameter a meaningful name (7).
• Ensure the Add slicer to this page checkbox is selected (8).
• Click Create (9).

Power BI now adds a slicer to the report canvas (10) and automatically generates a DAX measure for this parameter (11).

Step 2: Create a Field Parameter for KPIs (Measures)

Again, go to Modelling (12), select New Parameter (13), and choose Fields (14).

In the Fields Parameters window:

• Drag the relevant measures/KPIs into the Add and reorder fields box (16) from the Fields pane (15).
• Assign a suitable name to the parameter (17).
• Check the Add slicer to this page option (18).
• Click Create (19).

Now a slicer is added to canvas (20) and you can view the measure created by Power BI automatically (21)

Step 3: Now I can format the slicers for better appearance and usability.

Step 4: Configure the Table Visual

Remove all existing fields from the Table visual (22).

Drag the newly created parameter fields (Attributes[23] and KPIs[24]) into the Values(25) area of the Table visual.  The table will now dynamically display the columns selected through the slicers

Step 5: Select Only Required Columns

From the slicers, choose only the fields you wish to export. For example:  Date, Location, Description (26), Total Revenue, Total Fare, and Total Distance (Km) (27). Now, your Table visual displays only the selected fields (28).

Step 6: Export the Data

Finally, click the ellipsis (⋯) on the table visual and select Export Data (29)

Now, only the columns selected through the slicers will be exported to the CSV file(30)

Now I added a tooltip option, when I’m hover over the help icon it’s showing the text. This helps users clear understanding. 

This technique provides a flexible, user-controlled way to export exactly the data you need—no more, no less!

Hope it is clear.

Thank you!!

With Regards

Inturi Suparna Babu