Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

display all Dimension items in Matrix

Hi everybody,  I am currently facing issue to show all Items(Items is my dimension) in  matrix visual.  I have one table generated by APPENDING five excel files in power BI, three excel files havin...
Need Help
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    5 years ago

    Anonymous , I such case it is better to have independent date table, because they way filter behaves in power bi

     

    refer

    Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE

Ashish_Mathur's avatar
Ashish_Mathur
Icon for Super User rankSuper User
5 years ago

Hi,

Try this measure

=coalesce(average(consolidated[avg_spend]),0)

Hope this helps.