Forum Discussion

brendaivett's avatar
brendaivett
Icon for Advocate II rankAdvocate II
10 years ago

Where are the "see records" columns setup?

Hi,   When I right-click on a visualization report, I get the "see records" option, I click on it, and I get the right number of records but a column that I'd like displayed as well, is not showing...
Tips and Tricks
brendaivett's avatar
brendaivett
Icon for Advocate II rankAdvocate II
10 years ago

Hi everybody,

 

I found in this link http://community.powerbi.com/t5/Desktop/In-line-hierarchy-levels-for-drill-down-in-power-bi-desktop/td-p/33427 

 

this "Seems like it is picking up all the text based fields when you see click records."

 

It doesn't make sense, but that's how it works, the "see records" include the fields that are already part of the visualization you're working on, plus the text based fields left on your table, so, I tested changing the datatype of one of my measure fields that I wanted to show into a text, and when I right-clicked for the "see records" option, now I could see the field I was testing with in the records.

 

Hope this helps! at least while it's fixed.

 

Brenda

jerome's avatar
jerome
Frequent Visitor
10 years ago

Thanks, that works, but is quite unfortunate that we need to do this work-around. I was really excited when they added the "See Records" feature. That feature is incredibly valuable for us. However, that certain fields are filtered out is a major flaw. We also need to be able to rearrange fields the way we want to. 

  • Vicky_Song's avatar
    Vicky_Song
    Icon for Impactful Individual rankImpactful Individual
    10 years ago

    jerome, brendaivett, Anonymous, jcarville, ZLJ, as what I mentioned in this case, you can use Values pane in Visualization to include, exclude and re-order some columns. Then, you will get columns exactly what you want when you export data.

     

    Does it work for you?

    • ZLJ's avatar
      ZLJ
      Icon for Advocate II rankAdvocate II
      10 years ago

      Hi Vicky_Song  

      Do you mean in the original visualization or in the See Records visualization?

      When i do this to the original, it then distorts the visual as it is pulling in values i do not want included at all.  When i add them in See Records, they dont keep once you go back to the report and drill in again later / via another route.

      • Vicky_Song's avatar
        Vicky_Song
        Icon for Impactful Individual rankImpactful Individual
        10 years ago

        ZLJ, I mean in the 'See Records' visualization. You are right that these filters don't keep once go back to the report, however, you can take it as a workaround to choose columns you want when you're going to export data. I'm still waiting for the updates from our senior engineers on how 'See Records' works. Will reply back once I get any updates.  

    • GlenRebusora's avatar
      GlenRebusora
      New Member
      9 years ago

      hello Vicky,

       

      i cant find the Values pane in my power bi free version, can you please advise me how to get that pane?

       

      thanks and regards,

      glen

       

  • petersi's avatar
    petersi
    Icon for Helper II rankHelper II
    8 years ago

    What if you want to configure what is displayed by default when the user selects see records. This optiopn is only good for the user to perfrom manually. It makes no sense why non test fields that are not included in the explicilt visualization do not show up automaticvally in See Recxords. And when you do add them they do no0t stay as part of the configuration for the visualization.