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.
Step 1: Create a Field Parameter for Attributes
Navigate to the Modeling tab (2). Click the New Parameter dropdown (3), and choose Fields (4).
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 meaningful name to the parameter (17). Check the Add slicer to this page option (18). Click Create (19).
another slicer to the report canvas (20) and automatically generates a DAX measure for this parameter (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!
I hope it's clear blog for evenryone.
Thank you all
Regards
Inturi Suparna Babu
Super User
