In this blog, we’ll learn How to Create different type of Buttons in PowerBI. Firstly, we have to understand what is it and when should we use it.
Button is a visual, that can be help to create interactive and dynamic reports. It can be used for navigation, actions and providing additional information.
Dataset Description
These data sets contain sales information for a retail business. Transactional data, which includes specifics about goods, sales numbers, and customer information that has been recorded over time, is part of the information.
You can access the dataset here.
Date | Date of Sale |
Product | Product that has been sold |
Quantity | Quantity of product |
Price | Price of single quantity of product |
Rate | % Tax + |
Discount | Discount on total Sale |
Customer | Name of Customer |
Location | Location of Customer |
Total Sale | Total sale of one time |
Total Profit | Total profit of one purchasing |
Target Sale | Decided profit on one purchase |
Sample of Data:
Steps to create different types of buttons in PowerBI:
Step1: Open your PowerBI Desktop on your Device
Step2: Click on Get Data button in Home Ribbon and select Text/CSV.
Note:
- You can select any option according to your dataset format, it may be an Excel file, JSON or any other file format that holds your data.
- You can Scrape data using python also or connect to online server.
- There are more than 160 supporting data source types.
Step3: Open Prompt box will be open to select your text or csv file.
Step4: After selection of dataset, It will pop up a window for Load OR Transform Data. Click on Load to use data on PowerBI.
Note: If your dataset required some enhancement or cleansing, Click on Transform Data either just click on Load.
Step5: In the following picture, data has been loaded successfully.
There are nos. of button present in Power BI, we’ll try them one-by-one.
# Button 1
Step1: Select Insert Button from Ribbon and click over Buttons to select given nos. of button.
Note: You can create as many pages after click on .
Step2: Select Left arrow to create a button to navigate between two report pages.
Note: We’ll create Left arrow on Page 2. Left arrow button will take us on page 1.
Step3: As showing in below, Letf arrow button has been created, Now we have to set Action on it.
Step4: set the fields as shown in below:
# Button 2
Step1: Select Insert Button from Ribbon and click over Buttons to select given nos. of button.
Note: You can create as many pages after click on .
Step2: Select Left arrow to create a button to navigate between two report pages.
Note:
- We’ll create Right arrow on Page 1.
- Right arrow button will take us on page 2.
Step3: As showing in below, Right arrow button has been created, Now we have to set Action on it.
Step4: set the fields as shown in below:
# Button 3
Step1: Select Insert Button from Ribbon and click over Buttons to select given nos. of button.
Note: You can create as many pages after click on .
Step2: Select Back to create a button to navigate between two report pages.
Note:
- We’ll create Left arrow on Page 3.
- Back button will take us on previously clicked page.
Step3: As showing in below, Back button has been created, Action has been already set on it.
# Button 4
Step1: Select Insert Button from Ribbon and click over Buttons to select given nos. of button.
Note: You can create as many pages after click on .
Step2: Select Q&A to create a button to find an insight about your dataset.
Note: We’ll create Q&A on Page 4.
Step3: As showing in below, Q&A button has been created, Action has been already set on it.
Step4: After click on Q&A button using ctrl + Click:
Note: You can try suggested insights or try by yourself by type query in input field.
# Button 5
Step1: Select Insert Button from Ribbon and click over Buttons to select given nos. of button.
Note: You can create as many pages after click on .
Step2: Select Blank to create a button to navigate or customize according to requirement.
Note:
- We’ll create Blank on Page 5
- We’ll apply web link on this Blank button.
Step3: As showing in below, Blank button has been created, Now we have to set Action and Style on it.
Step4: set the fields as shown in below:
Note:
- Font: Segoe UI Bold
- Web URL: https://www.dataspoof.info
Step5: Now after click on DataSpoof button, you’ll go on www.dataspoof.info with your default browser.
Note:
- You can use shape to build your button with all above existing feature
- Example: You can build a button with Web URL, Page Navigation etc.
- You can do the same thing with image also.
# Button 6
Step1: Select Insert Button from Ribbon and click over Shapes to select given nos. of shape.
Note: You can create as many pages after click on.
Step2: Select Rounded Rectangle to create a button to navigate or customize according to requirement.
Step3: As showing in below, Rounded Rectangle has been created, Now we have to set Action and Style on it.
Step4: set the fields as shown in below:
Note:
- Font: Segoe UI Bold
- Web URL: https://www.dataspoof.info
Step5: Now after click on DataSpoof button, you’ll go on www.dataspoof.info with your default browser.
Note: You can use shape to build your button with all above existing feature.
# Button 7
Step1: Select Insert Button from Ribbon and click over Image to import an image from your device.
Note: You can create as many pages after click on .
Step2: A Open Window will display to choose image file, select one and click on Open Button.
Step3: As showing in below, image has been imported, Now we have to set Action on it.
Step4: set the fields as shown in below:
Step5: Now after click on LEARN MORE image (will act like button), you’ll go on www.dataspoof.info with your default browser.
Conclusion
We have seen some buttons in PowerBI above and found that this is the visual which can interact with other views, report pages, and external sources etc. Buttons are essential elements in interactive visuals and dashboards. They allow users to perform specific actions, such as navigating between views, filtering data, triggering external processes, or opening links to external sources.
If you like this blog, you can share it with your friends or colleague. You can connect with me on social media profiles like LinkedIn, Twitter, and Instagram. If you have any doubt feel free to comment.
- 👏 Like for this article and subscribe to our newsletter
- 📰 View more content on my DataSpoof website
- 🔔 Follow Me: LinkedIn| Youtube | Instagram | Twitter
