Forum Discussion

newyorker's avatar
newyorker
Helper I
6 years ago

Cannot add a column to tooltips field

Hi folks, I am using a simple standard pie chart here. I cannot seem to add a column to the tooltips field. It works everywhere else, but this specific model I am working with won't let me. This mo...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Any solutions for this? I am also having the same issue.

newyorker's avatar
newyorker
Helper I
2 years ago

Hi Anonymous unfortunately it was not. This was the response I received from them.

 

-----------------------------------------------------------------


Cx has created a report using dataset connector in Power BI desktop ( Datasource of dataset: SSAS Live connect ) and when cx try to use the Visual tooltips and drag the column in the Tooltip field, it doesn't accept any column. We also tested directly by opening the dataset report pbix file and tried to use the visual tooltips but it doesn't accept any column.

 

This behavior is by design. This data model does not provide an option to convert category fields into measure by automatically applying an aggregation. We don’t allow aggregates over columns in several different situations (SSAS Multidimensional models, SSAS Tabular with calculation groups, DQ to SAP HANA or SAP BW). Column aggregates may have performance issues (MD models), may have unexpected semantics (calculation groups), or may simply fail (DQ to SAP).
Here you need to work around this by writing a measure that returns the text value that you like to display

 

-----------------------------------------------------------------

 

Sorry I couldn't be of much help.