Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

See Records and numeric fields

Hi All,    Just wanted to see if this 'just me' or if I am missing something obvious?   I am using Power BI Desktop (August 2018 but similar behaviour in previous versions).   I have, for examp...
Need Help
Show and Tell
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

I am unable to reproduce your issue in Power BI Desktop August 2018, what is your data source? You can review my example below.



Regards,
Lydia

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Lydia, 

     

    Thanks for trying to replicate. My source is a dataset hosted in the Power BI service (but I dont think it is to do with the source - probably a setting on columns like data type maybe?)

     

    It's difficult for me to show you an example because of data confidentiality but this is an example data row:

     

    When I click through to underlying records from a chart the following fields from the fact table are automatically selected/de-selected - the fields that are deselected are dates or integers (particularly note Appt Arrival SDT and Appt Mins ITS from the screenshot above). I can of course tick the deselected fields and this temporarily re-adds them to the view of the record when I click 'see records' but they only stay there as long as I have the 'see records' pane open for. 

     

     

    I'm sure I'm just missing something obvious?

     

    Thanks, 

     

    pbix. 

    • HotChilli's avatar
      HotChilli
      Community Champion
      7 years ago

      I agree with what you are seeing.

       

      From the ms documentation

      "When you select See Records for a data element, the Power BI Desktop canvas displays all the data associated with the selected element."

       

      Please see this thread see records

      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago
        Thanks HotChilli.

        Glad it’s not just me then. I’ve had a read through the thread you linked to - it looks like a couple of partial hacks to make some non-text fields appear in ‘see records’ but not a single fix to always return all fields associated with the record? I know our report consumers will unfortunately whine if they cannot see all the underlying fields associated with records.

        Mods - have I interpreted this correctly?

        Thanks :)

        pbix