How to use Power BI Visual Level filter and Add today's date filter on the data
In this tutorial, we explain how to use Power BI to add a visual level filter and filter data based on today's date dynamically each day
Watch this video to know more.
For any business query please drop us a message on [email protected]
Step by Step details can be found in the link below
/ power-bi-create-dynamic-date-filter-and-vi...
To practice the tutorial and download the PBIx file click here:
https://peritossolutions.com/pbix-dow...
To know about our reporting service offerings click here:
https://peritossolutions.com/services...
Formuluas Used in the tutorial:
sumx(FILTER(‘data’, ‘data’[Search Name]=”ABC-MISC”),[Total Amounts for Balance Sheet])
ABC MISC total = sumx(FILTER(‘data’, ‘data’[Search Name]=”ABC-MISC”),[Total Amounts for Balance Sheet])
Net Profit total = sumx(FILTER(‘data’, ‘data’[Search Name]=”Net Profit”),[Total Amounts for Balance Sheet])
Cashbox Total = sumx(FILTER(‘data’, ‘data’[Search Name]=”CASH BOX”),[Total Amounts for Balance Sheet])
References:
https://docs.microsoft.com/en-us/powe...
https://docs.microsoft.com/en-us/dax/...
Watch video How to use Power BI Visual Level filter and Add today's date filter on the data online without registration, duration hours minute second in high quality. This video was added by user Peritos Solutions - Reporting and Data Analytics 16 August 2019, don't forget to share it with your friends and acquaintances, it has been viewed on our site 5,925 once and liked it 2 people.