How to use a bookmark and a button to show & hide visuals (and other bookmark magic tricks).Button to hide a simple object. Getting a simple bookmark button pair working together is easy in Power BI. Here is how you do it. In this we discuss how to use, Button to show and hide a square object Button to show and hide a Chart Visual Let's...Feb 4, 2024 · 3 min readvirajr.hashnode.dev
Get distinct values from a column and add them to a dropdown.When any SharePoint list column is assigned to a Drop down it shows all item in it, unique and duplicates. this is really annoying in situations where we use the dropdown to filter a gallery. Ideally the drop down as the drop down supposed to show on...Jan 14, 2024 · 2 min readappylittle.hashnode.dev
Power Automate: How to get todays date and current time.We can go down 2 paths to get current date or current datetime in Power Automate. Using Inbuilt Action Using formula How do I get the todays date and time without writing formula? This is the easiest method, and you don't have to compose any form...Dec 31, 2023 · 2 min readappylittle.hashnode.dev
IF Statement using Power QueryIf you're stuck with a syntax error and looking for the short answer, here it is. if Condition 1 then results if true else results if false if Condition 1 then results if true else if Condition 2 then results if false ...Nov 26, 2023 · 5 min readvirajr.hashnode.dev
Splitting a power bi line chart up into several lines based on year.using Power query or DAX https://youtube.com/shorts/xnb4Q9zNe-U?feature=share Sales data for the first example, we have a generic sales dataset. It has Order date and Profit etc columns plus 4 years' worth of data. We can add these 2 columns to a ...Nov 19, 2023 · 1 min readvirajr.hashnode.dev
