Forum Discussion

rashidanwar's avatar
rashidanwar
Icon for Advocate II rankAdvocate II
2 years ago
Solved

How to Keep All Values of a Field When Using Measure on a Table Visual

I have a dataset in Power BI desktop. It contains 3 columns of data. title, approval_date, and amount. I have also a measure named approved_amount. The measure is summing the amount column where app...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi rashidanwar 

     

    Glad to hear you solved the problem yourself! Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

     

    Best Regards

    Zhengdong Xu
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rashidanwar's avatar
rashidanwar
Icon for Advocate II rankAdvocate II
2 years ago

Hi bhanu_gautam, I did a work around as explained below. If anyone could suggest a better solution to avoid additions of calculated column and conditional formatting, that would be great.

My solution:

I created a calculated column named "approved_amount_new." This column uses an IF statement to assign 0 to rows where "approval date" is blank and retains the original amount otherwise. By using "approved_amount_new" in the table visual, I ensured all titles were displayed. I then applied conditional formatting to make zeros in the "Amount" column transparent.

 

 

 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi rashidanwar 

 

Glad to hear you solved the problem yourself! Could you please mark your post as Answered? It will help the others in the community find the solution easily if they face the same problem as yours. Thank you.

 

Best Regards

Zhengdong Xu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.