locked
need dropdown column in powerpivot RRS feed

  • Question

  • Hi

    I need dropdown column in powerpivot in excel 2013

    How to achieve this.

    • Moved by L.Hl Wednesday, April 1, 2015 2:08 AM
    Tuesday, March 31, 2015 10:16 PM

Answers

  • What you likely want is an Excel table created from a DAX query, with an added column having Data Validation List property. If you don't want this, what you want is not possible.

    Unrecognized Excel MVP (UEM)

    • Marked as answer by Siva440 Thursday, April 2, 2015 4:47 PM
    Wednesday, April 1, 2015 9:27 PM

All replies

  • Hi

    This is the forum to discuss questions about Microsoft Excel develop (VBA, Automation). For your question is more about PowerPivot for Excel, I will move this thread to the PowerPivot forum.

    The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us.

    Thank you for your understanding.

    Best Regards

    Lan


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.

    Wednesday, April 1, 2015 2:08 AM
  • If your powerpivot is created, how about add a filter to achieve dropdown column.

    Powerpivot :

    https://msdn.microsoft.com/zh-cn/library/gg413497

    And add filter you can try this Excel API,after download and add dll to your project you can refer the following code:

      Workbook workbook = new Workbook();
                workbook.LoadFromFile("DataTable.xlsx");
    
                Worksheet sheet = workbook.Worksheets[0];
    
                sheet.ListObjects.Create("Table", sheet.Range[1, 1, sheet.LastRow, sheet.LastColumn]);
    
                sheet.ListObjects[0].BuiltInTableStyle = TableBuiltInStyles.TableStyleLight9;
    
                workbook.SaveToFile("Filter.xlsx", ExcelVersion.Version2010);

    REF:http://www.e-iceblue.com/Tutorials/Spire.XLS/Spire.XLS-Program-Guide/Data/How-to-filter-data-in-Excel-in-C.html

    Wednesday, April 1, 2015 2:25 AM
  • I want user editable column in pivot table and the column should be linked to pivot.

    user can update true or false to that specific row in pivot table.

    Wednesday, April 1, 2015 5:00 PM
  • What you likely want is an Excel table created from a DAX query, with an added column having Data Validation List property. If you don't want this, what you want is not possible.

    Unrecognized Excel MVP (UEM)

    • Marked as answer by Siva440 Thursday, April 2, 2015 4:47 PM
    Wednesday, April 1, 2015 9:27 PM