Forum Discussion

breezecoolioo's avatar
breezecoolioo
New Member
10 years ago

Ability to hide data in a calculated Measure - PowerBI Desktop

I have created a table from the dataset by showing the cumulative total of a particular item in one column. Can i hide data as shown in the attached Image in "Measure 3" ad "Measure 4" from "Measure ...
Need Help
asocorro's avatar
asocorro
Icon for Skilled Sharer rankSkilled Sharer
10 years ago

Why don't you create a fifth column that has the currently available value.  Something like

 

Measure5 = IF(ISBLANK(measure3), measure4, measure3)

 

You can create a chart with both measure3 and measure4 and only the non-blank values will be shown, but you will have two series/columns and that may not be the kind of visual you want to display.

  • breezecoolioo's avatar
    breezecoolioo
    New Member
    10 years ago

    Thank you very much for you quick reply. Perhaps, I did not make my question very clear. I need "Measure 3" and "Measure 4" derived from Measure 1 and Measure 2, which I am not able to create. When I write a formula, I dont find the Date column for some reason. :( 

    • asocorro's avatar
      asocorro
      Icon for Skilled Sharer rankSkilled Sharer
      10 years ago

      That's odd.  Can you share the formula you are trying to write or the pbix file?

      • breezecoolioo's avatar
        breezecoolioo
        New Member
        10 years ago

        I am new here, can you please tell me, how can I add a file. I just see options for Image and videos.

         

        regards,