Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Nevill
New Member

Dashboard filter output tabular format

‎12-30-2023 02:49 AM

Dear All,

 

I am a newbee to Powerbi and learning to create dashboards. I am currently making a powerbi dashboard for vehicle stock inventory at dealerships. I have kept a slicer to filter the type of vehicle and then bar chart for dealers. Post selecting the vehicle type and dealer i want to see the complete details which is available in excel rows for particular dealer but i am unable to achive it. Kindly guide in this respect.

 

Even when i export the data to excel i only get count and not the complete data.

 

Thanks in advance.

Labels:
Message 1 of 5
190 Views
0
4 REPLIES 4
Nevill
New Member

‎01-01-2024 03:41 AM
Dealer CodeDealerLOBPPLPLChassis NoTM Invoice NoTM Invoice DatePurchase Price for DealerLogical StatusPhysical StatusManufacturing DateStock Age CodeStock AgeModelColour# of VehiclesManufacturing YearTD Vehicle FlagTransporter Name
1001111INDIA Motors RajasthanBusesM&HCV BusesLPO1618TCMAT789028P5D048117641652331-05-20232661317.68AvailableReceived - OK01-04-2023EAbove 120 Days1618TC 12023NNATIONAL TRANSPORT SERVICES
1001112INDIA Motors DelhiHCV CargoMAV 28LPT 2821MAT789028P5D048127641652426-09-20232837542AvailableReceived - OK01-08-2023A1-30 Days2821 12023NNATIONAL TRANSPORT SERVICES
1001113INDIA Motors HaryanaHCV ConstMAV Tippers 28SIGNA 2830.K. FBVMAT789028P5D048137641652514-10-20234758690.51AvailableIn Transit01-09-2023A1-30 Days2830TC 12023NNATIONAL TRANSPORT SERVICES
1001114INDIA Motors OrissaICV TrucksICV 10T - 12T1212 LPTMAT789028P5D048147641652630-01-20231983636.16AvailableReceived - OK01-01-2023EAbove 120 Days1212 12023NNATIONAL TRANSPORT SERVICES
1001115INDIA Motors KeralaLCVLCV 4T PU407 GOLDMAT789028P5D048157641652731-08-20231246254.08AvailableReceived - OK01-06-2023B31-60 Days407 GOLD 12023NNATIONAL TRANSPORT SERVICES
1001116INDIA Motors Tamil NaduMCV TrucksMCV LPT 19ULTRA1918 FBVMAT789028P5D048167641652831-10-20222468178.56AvailableReceived - OK01-10-2022EAbove 120 Days1918 12022NNATIONAL TRANSPORT SERVICES
1001117INDIA Motors BiharPickupsIntraIntra V10MAT789028P5D048177641652930-09-2023715653.12AvailableReceived - OK01-07-2023A1-30 DaysINTRA V10 PICKUPTHUNDER_GOLD12023NNATIONAL TRANSPORT SERVICES
1001118India Motors KarnatakaScPassWingerWinger-DeluxeMAT789028P5D048187641653030-09-20231751509.76AvailableIn Transit01-09-2023A1-30 DaysTATA WINGERPEARL_WHITE12023NNATIONAL TRANSPORT SERVICES
1001119India Motors GujaratSCV CargoTata AceAce Gold CNGMAT789028P5D048197641653130-07-2023595113.6AvailableReceived - OK01-07-2023C61-90 DaysTATA ACEARCTIC_WHITE12023NNATIONAL TRANSPORT SERVICES
1001120India Motors MaharashtraSCVPassMagicMagic EXPRESSMAT789028P5D048207641653229-07-2023603316.23AvailableReceived - OK01-07-2023C61-90 DaysMAGIC EXPRESS PETROL 9+DARCTIC_WHITE12023NNATIONAL TRANSPORT SERVICES
Message 5 of 5
66 Views
0
v-rzhou-msft
Community Support
Community Support

‎12-31-2023 11:44 PM

Hi @Nevill ,

 

According to your statement, I think you want to see details in your report or in exporting excel.
1. If you want to see detail data in Power BI Report, you can create a table/matrix visual with the columns you need.

Or you can try page tooltip: Create report tooltip pages in Power BI - Power BI | Microsoft Learn

 

2. If you want to see unsummarize data instead of summarize data in your exporting file, I think you can try to export unsummarize data in Power BI Service. As far as I know, Power BI Desktop only support us to export summarize data into csv file. However, in Power BI Service, we can choose to export unsummarize /summarize data into csv / excel.

For reference: Export data from a Power BI visualization - Power BI | Microsoft Learn


Best Regards,
Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Message 4 of 5
95 Views
0
Ritaf1983
Super User
Super User

‎12-30-2023 03:03 AM

Hi @Nevill 

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
https://community.powerbi.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-...
Please show the expected outcome based on the sample data you provided.

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Message 2 of 5
174 Views
0
Nevill
New Member
In response to Ritaf1983

‎01-01-2024 03:46 AM

I have provided the sample Data. All I want to create a dashboard where i would select the LOB and then select the Ageing of vehicle and then post clicking on selection i should be able to view data in tabular format as below. Hope you got my point. Currently i am getting data in count only not the whole column data. I want that whom so ever check the dashoard and wants to download the data in excel format must get complete details.

 

Nevill_0-1704109489848.png

 

Message 3 of 5
84 Views
0

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

View All