Forum Discussion
Issue displaying SQL table data
Hi, I am creating a dashboard and I have numerous graphs based on SQL data and all work fine. I want to add a control that displays text data from another table. The data is as follows in SQ...
I maybe on the wrong track here but I think the key using the Matrix visual. This visual requires a value - you will note that the value Power BI selects is 'First - LoggedBy' - this means it returns the value in the first row of that column. That may well be a blank!
If you use a Table visual and ensure that the columns in the Values section are set to "Don't summarize" then you should be able to see all the values. Make sure that the ID column is included because the Table visual will 'summarize' for matching values (if memory serves me right) and therefore you won't see all the values unless you include the ID column.
Hi The table idea didnt work either, see below. Its weird!