Line and column chart having issues with dynamic title - Can't display the visual

Question

Hi,I am having troubles with a chart if I try to add a title with conditional formating (from a measure).It says "Can't display the visual" - Query (156,12) Each table argument of 'UNION' must have the same number of columns.Also, the "General" ribbon inside the "Format your Visual" disappears and it's not longer possible to remove the title. The only way is to undo the last action.Here are some details of the chart used:Chart used: Line and stacked column chartX-axis: Table3[ColumnH]&nbsp; -&gt; Option "Show items with no data" is activatedColumn y-axis: Table1[Measure1]&nbsp;(with Measure1= SUM('Table1'[ColumnM])Line y-axis: Table1[Measure2] (with Measure2= CALCULATE([Mes2], ALL('Table2'[ColumnA]), 'Table2'[ColumnA]="ABCD", 'Table1'[ColumnY]="XYZ", ALL(Table1[ColumnZ])))Column legend :&nbsp;Table1[ColumnZ]Title : Table1 &gt; Measure &gt;&nbsp;Title = "Title defined via measure"IMPORTANT DETAIL: if I remove the option "Show Items with no data", the chart is working properly.Ps: I tried to change the relationships between the 3 tables used but nothing changes.Thank you for your help.Best regards,Thibaut

anonymous · Answer

Hi&nbsp;Thibaut21908&nbsp;
&nbsp;
The error message “Each table argument of ‘UNION’ must have the same number of columns” suggests that there might be an issue with the DAX expression used in your measure for the title.&nbsp;
&nbsp;
Ensure that all tables used in the&nbsp;function have the same number of columns and compatible data types.
&nbsp;
The "general" ribbon disappears, which may be an error or a conflict caused by conditional formatting.
&nbsp;
Instead of using a complex measure for the title, consider using a simpler measure or a static title to see if the issue persists.
&nbsp;
Regards,
Nono Chen
If this post&nbsp;helps, then please consider&nbsp;Accept it as the solution&nbsp;to help the other members find it more quickly.

thibaut21908 · Answer

Hi,Thank you for your answer.I checked and all the tables and the model used are correct.There are no conditional formatting used in the visuals.As per the measure, I checked doing a fake Power BI with dummy values and the issue still persists.If I have the Title as a measure, the visual fails. However, with a text, it works properly.The measure used =&nbsp;"Title defined via measure"As I see this, it looks like an issue maybe with this version of Power BI?I am using:&nbsp;Version: 2.124.1960.0 64-bit (janvier 2024)Best,&nbsp;

Forum Discussion

Related content

Dynamic Column headers

Dynamic Column Name

Dynamic Variable in Calculated Columns

Dynamic Image Display

Display dynamic column header in a Matrix Visual