Forum Discussion

Nevill's avatar
Nevill
New Member
2 years ago

Dashboard filter output tabular format

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.

Need Help

4 Replies

    • Nevill's avatar
      Nevill
      New Member
      2 years ago

      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.

       

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

  • Nevill's avatar
    Nevill
    New Member
    2 years ago
    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