Forum Discussion

tobiasmcbride's avatar
tobiasmcbride
Helper III
6 years ago

Grouping and formatting issues table

Hi,   Have noticed couple of areas I'd like to check if I am doing things right: I have two separate tables - one is with actual financial data and the other has our budget. We can and have been ab...
Need Help
v-kelly-msft's avatar
v-kelly-msft
Community Support
6 years ago

Hi tobiasmcbride ，

 

1.To make blank value  appear:

So the acutals and budget are from 2 tables right? If so ,create a dim table,then create a relationship between dim and actuals, dim and budget.

 

2.About group:

In the dim table,right click on the column of category,choosing "new group",then choose each row you dont need to be grouped and others which are needed to be grouped in the other ,and you will see:

 

Best Regards,
Kelly
 
Did I answer your question? Mark my post as a solution!

 

 

  • tobiasmcbride's avatar
    tobiasmcbride
    Helper III
    6 years ago

    Hi,

     

    If I do that, the slicers/filters do not work for the budget. Also blank categories appear and no IT Expenses appear in the month view when I know there is a budget entry for that even though no actuals view.

     

    Not sure what I am doing wrong? 

    • v-kelly-msft's avatar
      v-kelly-msft
      Community Support
      6 years ago

      Hi tobiasmcbride ,

       

      Can you show me your .pbix file if it's not confidential?

       

      Best Regards,
      Kelly
       
      Did I answer your question? Mark my post as a solution!