How can I have total of last year or next year budget while keeping MTD and YTD (which are relating to slicers)

[BrianJ]

@ammu

In a different note, is there any way to highlight particular row? in my case, I would like to highlight Net Result row (which is not actual total, instead I calculated in SQL to get the Net Result.

Please check out the thread below, which I think will address your row formatting question

How to highlight Total Row

@Tahir, OK, I put together an example using Sam’s Financial Reporting Showcase data. Here’s the DAX for the Highlight calculated column for the two rows I chose to highlight: Highlight = SWITCH( TRUE(), 'Financial Categories'[Financial Statement List] = "COS - Equipment", 1, 'Financial Categories'[Financial Statement List] = "COS - Prize Fund", 1, BLANK()) Then just conditionally formatted each of the fields in the table based on the value of the Highlight column. The key i…

With regard to your other question, the answer I think will depend on what your data model looks like. If you could please post your PBIX file, that would allow us to provide a specific solution. If you have any confidential data in your file, here are some quick and easy techniques to use in power query to mask sensitive data:

How To Mask Sensitive Data In Power BI

I hope this is helpful.

• Brian