Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I have a strange one here.
I have a clustered column that breaks down company divisional sales by year, when I select one division on the clustered column chart all of my other charts normally filter through to highlight the related data. This was all working well until this morning.
On My desktop version when I click on the column that contains Blanks or No division set, it returns the following error message for all of the associated other graphs.
Error Message:
Query (14, 42) Function 'CONTAINSROW' does not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
Strangely my online version which is the same in every way and was uploaded last week from the same file will filter through with no issues, this updates the data automtically twice a day.
Has anybody else encoureted this ?
Feedback Type:
Frown (Error)
Timestamp:
2017-04-18T08:42:03.9648681Z
Local Time:
2017-04-18T09:42:03.9648681+01:00
Product Version:
2.44.4675.521 (PBIDesktop) (x64)
Release:
March, 2017
IE Version:
11.0.9600.18537
OS Version:
Microsoft Windows NT 6.1.7601 Service Pack 1 (x64 en-US)
CLR Version:
4.5.1 or later [Release Number = 378758]
Workbook Package Info:
1* - en-GB, fastCombine: Disabled, runBackgroundAnalysis: False.
Peak Working Set:
580 MB
Private Memory:
438 MB
Peak Virtual Memory:
3.88 GB
Error Message:
Query (14, 42) Function 'CONTAINSROW' does not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values.
Telemetry Enabled:
True
Model Default Mode:
Import
Enabled Preview Features:
PBI_Snowflake
PBI_shapeMapVisualEnabled
PBI_allowBiDiCrossFilterInDirectQuery
Disabled Preview Features:
PBI_RedShift
PBI_Impala
PBI_EnableReportTheme
PBI_esriEnabled
PBI_pivotTableVisualEnabled
PBI_numericSlicerEnabled
Disabled DirectQuery Options:
DirectQuery_Unrestricted
Cloud:
GlobalCloud
Activity ID:
Time:
Version:
2.44.4675.521 (PBIDesktop)
Error Code:
QueryUserError
OData Error Message:
Failed to execute the query.
DPI Scale:
100%
Supported Services:
Power BI
Formulas:
Hi @thomaskelly,
>>Query (14, 42) Function 'CONTAINSROW' does not support comparing values of type Integer with values of type Text. Consider using the VALUE or FORMAT function to convert one of the values
Above message told about the issue is related to "CONTAINSROW" function(error parameters type), can you provide the detail content of this visual and the formulas?
Can you share the sample file or pbix file to test? It' is hard to reproduce the issue without sample file.
Regards,
Xiaoxin Sheng
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |