Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Can't display the visual

Hello, I have a clustered column chart visual that can't be displayed - I get the message "Unable to convert a value to the data type requested for table "column". The visual is supposed to show x...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
2 years ago

It seems the problem only arises when I choose departments based on my own connection table. These are the formulas that I use when filtering between departments in my slicer: 

StandardizedName =
SWITCH(
    TRUE(),
    'Connection Table'[Name] = "alternative name of a sub-department", "regular name for sub-department",
    'Connection Table'[Name] = "alternative name of a sub-department", "regular name for sub-department",
    'Connection Table'[Name] = "alternative name of a sub-department", "regular name for sub-department",
    'Connection Table'[Name] // Default Case
)
The above table is to merge the alternative name into the regular sub-department name, so data is registered across both types of name, and to make a slicer just based on the regular name.
And:
Group =
SWITCH(
    TRUE(),
    'Connection table'[StandardizedName] = "name of sub-department" || 'Connection table'[StandardizedName] = "name of sub-department", "name of my main department",
    'Connection table'[StandardizedName] = "name of sub-department", "name of main department (same name as sub)",
    'Connection table'[StandardizedName] = "name of sub-department" || 'Connection table'[StandardizedName] = "name of sub-department", "name of main department",
    'Connection table'[StandardizedName] = "name of sub-department", "name of main department (same name as sub)",
    'Connection Table'[StandardizedName]
)
This one is to merge two sub-departments into a main-department. In some cases the sub-department name is the same as the main-department.
And then ofcourse in the same table, I also have a column which connects department numbers with names. Does this help in any way?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thanks for MFelix's concern about this issue.

 

Hi, Anonymous 

I am glad to help you. 

 

Make sure that all names and department numbers in Connection table are correct and that there are no duplicate or incorrect entries.

 

Why is your DAX formula writing the same thing over and over again? For example:

StandardizedName =
SWITCH(
    TRUE(),
    'Connection Table'[Name] = "alternative name of a sub-department", "regular name for sub-department",
    'Connection Table'[Name] = "alternative name of a sub-department", "regular name for sub-department",
    'Connection Table'[Name] = "alternative name of a sub-department", "regular name for sub-department",
    'Connection Table'[Name] // Default Case
)

 

Could you please provide some sample data in your tables (exclude sensitive data) with Text format and your expected result with backend logic and special examples. It is better if you can share a simplified pbix file. Thank you.

 

 

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.