Power BI: Show Last Data Refresh on Dashboard

 To show last data refresh on Power BI report follow the below steps.

1. Open Report Query Editor Mode.

2. Clink on Get Data -> Blank Query

3. Once you have Blank Query table “Query1” in place under the Queries section, right click on it and rename it to “Last Refreshed Date”

4. Now, open the Advance Editor from the Home ribbon and paste the below M code.

let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source

5. Click on Close & Apply

6. Next step is to add a calculated measure field to use with the Date Last Refreshed column

          Date Last Refreshed = VALUES (‘Date Last Refreshed'[Date Last Refreshed])

 

 

Happy Learning !!

Power BI: Blank Replace by Zero

 When we need to replace blank values with 0, use below DAX formula for Measure.

Audit Count = IF (

    CALCULATE ( COUNT ( 'Audit Master Data'[Ref.] )) = BLANK (),

    0,

    CALCULATE ( COUNT ( 'Audit Master Data'[Ref.] ) )

)

Happy Learning !! :) 

Power BI : Slicer Impact on One Visual

 Sometime we have a requirement where slicer we created should be impacted only for certain visuals not for all. To achieve this follow below steps.

1. Select the slicer.

2. Go to Format from pane option.

3. Click on "Edit Interactions" 

4. Select the below option for which ever visuals you don't want slicer value to be impacted. 

5. Save the changes and enjoy. 

happy learning !! :)