Clustered Bar Chart and Matrix Chart

Question

Hello,I have a problem with the clustered bar chart and matrix chart.&nbsp;These two charts uses same value column. When I check I have seen that while bar chart shows the right value matrix chart doesn't show.&nbsp;For example if I want to choose a category in bar chart matrix brings the wrong value and shows the bar chart total.&nbsp;&nbsp;Can you please help?

amitchandak · Answer

Anonymous , Tried in my file this example
Measure 9 = DIVIDE(sumx(Sales,[Qty]*[Price]),SUM(Sales[Qty]))
&nbsp;
category on row, month on column, tried to filter, result is correct. with name seems they are column, Just check if there is any measure, or check the datatype (some issue)
&nbsp;
try like
column = DIVIDE(SUMX(firsttable, firsttable[column1]*firsttable[column2]*1.0),SUM('secondtable'[secondtablecolumn])*1.0,0)

amitchandak · Answer

Anonymous , can you share the formula, It can row-level calculation issue or all or allexcept has been used 
&nbsp;
Also refer: https://www.youtube.com/watch?v=ufHOOLdi_jk

anonymous · Answer

The formula is like below:&nbsp;column = DIVIDE(SUMX(firsttable, firsttable[column1]*firsttable[column2]),SUM('secondtable'[secondtablecolumn]),0)

amitchandak · Answer

Anonymous , this formula should have worked correctly. 
&nbsp;
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

anonymous · Answer

Unfortunately I cannot share the data or report because of the company policies.&nbsp;Do you have any idea why it can be?

Forum Discussion

Clustered Bar Chart and Matrix Chart

6 Replies

Related content

Clustered column chart incomplete legend

Need a stacked clustered column chart

Multiple line and clustered columns chart

Clustered Bar chart

Clustered column chart question