---
title: "Viraj Rathnayaka (@VirajR) | Hashnode"
description: "Data Analyst. Read the latest articles by Viraj Rathnayaka on Hashnode."
url: "https://hashnode.com/@VirajR"
---

@VirajR

# Viraj Rathnayaka

@VirajR · Sri Lanka · Joined January 2023

Data Analyst

### [How to use a bookmark and a button to show & hide visuals (and other bookmark magic tricks).](https://virajr.hashnode.dev/how-to-use-a-bookmark-and-a-button-to-show-hide-visuals-and-other-bookmark-magic-tricks?utm_source=hashnode&utm_medium=feed)

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...

3 min read · [virajr.hashnode.dev](https://virajr.hashnode.dev/how-to-use-a-bookmark-and-a-button-to-show-hide-visuals-and-other-bookmark-magic-tricks?utm_source=hashnode&utm_medium=feed)

[Feb 4, 2024](https://hashnode.com/posts/how-to-use-a-bookmark-and-a-button-to-show-hide-visuals-and-other-bookmark-magic-tricks/65bf3db77a7d1f8445dd0d4d)

### [Get distinct values from a column and add them to a dropdown.](https://appylittle.hashnode.dev/get-distinct-values-from-a-column-and-add-them-to-a-dropdown?utm_source=hashnode&utm_medium=feed)

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...

2 min read · [appylittle.hashnode.dev](https://appylittle.hashnode.dev/get-distinct-values-from-a-column-and-add-them-to-a-dropdown?utm_source=hashnode&utm_medium=feed)

[Jan 14, 2024](https://hashnode.com/posts/get-distinct-values-from-a-column-and-add-them-to-a-dropdown/65a3e298aadaa04b44649049)

### [Power Automate: How to get todays date and current time.](https://appylittle.hashnode.dev/power-automate-how-to-get-todays-date-and-current-time?utm_source=hashnode&utm_medium=feed)

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...

2 min read · [appylittle.hashnode.dev](https://appylittle.hashnode.dev/power-automate-how-to-get-todays-date-and-current-time?utm_source=hashnode&utm_medium=feed)

[Dec 31, 2023](https://hashnode.com/posts/power-automate-how-to-get-todays-date-and-current-time/65916e120dd5f04bf8c187e7)

### [IF Statement using Power Query](https://virajr.hashnode.dev/if-statement-using-power-query?utm_source=hashnode&utm_medium=feed)

(Almost) Complete Guide

5 min read · [virajr.hashnode.dev](https://virajr.hashnode.dev/if-statement-using-power-query?utm_source=hashnode&utm_medium=feed)

[Nov 26, 2023](https://hashnode.com/posts/if-statement-using-power-query/6562b8c70f24d90a429e6f23)

### [Splitting a power bi line chart up into several lines based on year.](https://virajr.hashnode.dev/splitting-a-power-bi-line-chart-up-into-several-lines-based-on-year?utm_source=hashnode&utm_medium=feed)

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 ...

1 min read · [virajr.hashnode.dev](https://virajr.hashnode.dev/splitting-a-power-bi-line-chart-up-into-several-lines-based-on-year?utm_source=hashnode&utm_medium=feed)

[Nov 19, 2023](https://hashnode.com/posts/splitting-a-power-bi-line-chart-up-into-several-lines-based-on-year/65599a8c43c3abdffdaa2eef)
