Forum Discussion
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 1" and "Measure 2" respectively. The logic is that the "Measure 3" shows data till a particular date (lets assume the date is today) and then the "Measure 4" column after that particular date. I want to build a graph from the last two columns so that the graph only shows the relevant section of the data. Can someone please help?
5 Replies
- asocorro
Skilled Sharer
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.
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
That's odd. Can you share the formula you are trying to write or the pbix file?
v-sihou-msftMicrosoft Employee
Hi breezecoolioo,
For your reporting purpose, the goal you need to achieve is combining the measure 3 and measure 4 column into one column. Since those columns are already populated, the method as asocorro supposes to work. Based on your sample data, it seems your measure 3 and measure 4 just return different column data at a specific date point. You can directly add a column like:
Column = IF(table[Dates]<"05/04/2016",table[measure1],table[measure2])
To add image and file, please refer to screenshot below:
Regards,
