Forum Discussion
Post ProdigyVisual Calculation_If Blank
Hi good day,
Can anyone help me on my visual calaculation, i want to hide the row if is blank.
Output
Thank you
Hi AllanBerces I think, visual calculations themselves do not directly remove blank rows, Instead you can use measure, which automatically removes blank. If you really need to use visual calculation, and want to hide blank rows then recreate the measure and place it in the "Filter on this visual" and filter out blank. For your case,
hrs = SUM('Table'[Earned]) + SUM('Table'[Remaining]) and placed it in the filter pane. See the image below:
Other way to exclue. For example, you can rewrite the visual calculation like below:hrss =IF([Earned]+[Remaining]=0, 0, [Earned]+[Remaining])
Then exclude only 0. See the image below:
if multiple blank rows, then control + click to multi select, and exclude.Hope this helps!!
If this solved your problem, please mark it as a solution!!
3 Replies
- shafiz_p
Super User
Hi AllanBerces I think, visual calculations themselves do not directly remove blank rows, Instead you can use measure, which automatically removes blank. If you really need to use visual calculation, and want to hide blank rows then recreate the measure and place it in the "Filter on this visual" and filter out blank. For your case,
hrs = SUM('Table'[Earned]) + SUM('Table'[Remaining]) and placed it in the filter pane. See the image below:
Other way to exclue. For example, you can rewrite the visual calculation like below:hrss =IF([Earned]+[Remaining]=0, 0, [Earned]+[Remaining])
Then exclude only 0. See the image below:
if multiple blank rows, then control + click to multi select, and exclude.Hope this helps!!
If this solved your problem, please mark it as a solution!!
AllanBercesHi shafiz_p thank you for the reply, working as i need.
- AllanBerces
if Blank on the hrs Column, will hide the row
thank you