Forum Discussion
Can't display the visual
Super UserAre you able to send a mockup?
I don't understand when you reference that the The visual is supposed to show xx data on y-axis and CalenderMonths on x-axis but then you talk about the departments and subdepartments.
Can you elaborate a litle on the final result you want to achieve.
Hi MFelix. On my page I have a slicer containing four different main departments. All the data on my visuals is then adjusted to the selected department - so there is relations between the different dataset tables and departments. There is a main date table "analysis vwTime" which has all the dates as well as the "CalenderMonthName". In terms of the visual I am talking about, which is a bar chart with "CalenderMonthName" on x-axis and "MyQMS Timeliness" data on y-axis. Every month shows a percentage of how well "MyQMS Timeliness" has performed in that specific month. I either use a date filter to filter in the last 1 years or in this year. Now the problem occurs when I choose, lets say, department 3, and that department doesn't have data registered for one or more months, then the visual says 'Can't display the visual - unable to convert a value to the data type requested for table "column'. I have tried all the simple options i feel like, such as choosing "Show items with no data", but still no luck. I also tried IF or COALESCE functions. The weird thing is then, that if I just have no department selected in my slicer and instead choose a department, also without data registered in all months, directly from "MyQMS Timeliness" table, no problem - it can still display the visual. So during my detective work I've come to the conclusion that it must be some sort of error in my "Connection Table" and it's relations, that doesn't make it able to show months when there is no data registered.
I hope this clarified it a bit. And again, thank you so much for your time! I really appreciate it.
- MFelix
How is the [MyQMS Timeliness] calculated you have send out information about the tables for the departments but not for this measure.
It seems weird to get an error of unble to convert a value to the data type requested for table column.Hi @MFelix. I cannot see the formula for my MyQMS Timeliness measure, as it is a Direct Query that I have not created myself. But it works fine when connected to the analysis Department table, which is the overall department table. I can't really seem to figure out why it won't convert a "null" value to show in my bar chart. The problem is that my Connection Table cannot show null values. I don't think the problem is in MyQMS timeliness, since I have the same problem in another visual R&U Timeliness (works fine when data in all months, but as soon as a "null" month occurs), there is a problem again. So it is only when there are null values within a month.