How to use Slicer Visual feature in Power BI (Preview).
Problem Statement: Hi there, and thanks for visiting the blog. Today, we’re going to concentrate on the Slicer Visual, which is among Power BI’s most engaging and user-friendly features. One kind of visual on a report page that filters other visuals is called a slicer. Slicers are displayed directly on the report canvas for everyone to utilize, eliminating the need to use the filter window that is limited to it. By enabling users to dynamically examine data at their own pace and in accordance with their needs, they greatly enhance the value of your reports. However, there are drawbacks to this Slicer visual, particularly when the developers were utilizing the tile layout. In order to counter this issue Microsoft released a new “Slicer Visual” in November 2023 Update to address this issue and enhance the user interface (UI) for users. NOTE: Currently this feature is in Preview. So, now let’s dive in to explore this new visual so that you can leverage it in your Power BI Report. As this feature is in Preview mode, we need to activate this feature from the “Settings in Power BI”. To do so follow the following steps and click on the “File” tab shown in the below screenshot. Then head to “Options and Settings” option as shown in the below screenshot. After clicking on the “Options and Settings” option click on the “Options” as shown in the below screenshot. After clicking on Options you will be directed to the below window, then click on the “Preview features” tab and tick the “Button Slicer Visual” and Click on “OK”. After turning on the feature and moving on to the visual pane in Visual view you will see the new Button slicer Visual as shown in the below screenshot. After getting the new Button Slicer Visual, we will see how it works and what features it contains. For that, I have considered demo data which consists of two tables which are having data of customers and Projects and it consists of a simple graph of No. of projects per Customer. And the Slicer consists of data of Accounts. Which we can see in the below screenshot. In the above screenshot, we can see that there are two slicers One slicer is the legacy one and the other is the new Button Slicer. We can see that the new button slicer is visually cleaner than the legacy one. Now let’s dive into the new “Button Slicer” “Format” Pane as shown in the below screenshot. Fig 1: New Button Slicer Visual Format Pane. Fig 2: Legacy Slicer Visual Format Pane. Now when we have seen the differences between the Visual Tab Options let’s see what is new in the New Button Slicer Visual section. a. Shape Section: This Section allows to formatting of the shapes of the button in the New Slicer. Below are the screenshot of the three options and outputs available for it. I. Rectangle Shape Options II. Rounded Rectangle (here you can see that we can customize each corner of the button) III. Snipped Tab, both top b. Layout Section: The above screenshot shows the layout section which has a Sub-Section, the Layout Sub-Section consists of the Alignment of text, Rows, and Columns in the visual, thus deciding the number of buttons in each row and column in the button slicer visual also we can define the Space between the cards. Moreover, we can also define the Overflow whether the Visual should have a continuous scroll or paginated Scroll, and the direction of the Overflow. The above screenshot represents the Continuous scroll and the below screenshot depicts the Paginated style Overflow. c. Callout Values This Section provides extra customization related to values. The below screenshot shows the comparison between the Values Section (Old Slicer Visual) and the new Callout Values (section) In the new slicer, visual new can see the State option which gives us more flexibility related to Customization. d. ImagesThis section allows us to add the Image data for the button and gives us the option to customize the image such as size, transparency, Blur, or if you want to set it as a Background, Moreover, you can also customize the position of the image. e. Buttons. The above screenshot highlighted section shows the Button section which allows you to do minute customization over a button of the slicer visual. These were all the changes in the Visual Tab, in the Properties Tab there is only one section added in this new visual which is the option to add a tooltip and its related Customization. The below screenshot shows the following section and its Sub-Sections. This is it for the new Button Slicer Visual that was introduced for Power BI Desktop. If you like this blog then please like the blog and feel free to comment for any suggestion.
How to create a chatbot using Generative AI using MS Copilot Studio
Hello everyone, and welcome to the blog, In this blog, we are going to create a simple yet effective chatbot by using Generative AI by just providing the Website URL or a document with some information related to a Topic. Prerequisite: Login to Microsoft CoPilot Studio and sign in or sign up for a free Microsoft Copilot Studio instance. Let’s Start by creating a new CoPilot as shown below: Following this step, you will be able to configure the CoPilot Name and the language that you would like Copilot to speak. There are several languages available for selection. I’ll be sticking to English for the time being. You can see that there is a dialog box to enter the website URL that you want to use to generate the generative answers in the screenshot above. I’ve entered the Amazon URL for the time being. After completing the required fields, click Create to start a new CoPilot. And allow time for the CoPilot to be built. After giving some time to build Microsoft copilot you will get you Chatbot as shown in the screenshot below I’ve now included a website URL so you can get the response. So let us try posing a relevant question. As you can see in the screenshot above, I asked a question regarding the price of the iPhone 15, and it produced an answer based on the reference link I gave. As you can see, it provides the appropriate link for you to purchase the item. Let’s click the link to view the outcome. The same is shown in the screenshot below. Here’s how to enhance the intelligence and effectiveness of your chatbot and apply it to business solutions to utilize your customer experience in a low-code, no-code manner. Additionally, you can increase the number of website URLs that your chatbot cites. Navigate toward the Generative AI Tab, as indicated in the screenshot below, to add more website URLs. The Generative AI Tab overview is displayed in the screenshot below. You can add more website URLs in the places on the right that are highlighted. in order for your chatbot to respond to additional inquiries. You can also see that you may give your bot document references to generate extra answers in the highlighted section above. Let’s explore how we may upload a document and provide our bot with extra data. As seen in the screenshot below, I have a Word document with information about Shekaru, an Indian giant squirrel. The chatbot won’t be able to provide you with information about it if we ask it before uploading the documents. An example of this can be seen in the screenshot below. Fig. 1: Because we haven’t given the chatbot any information about Shekaru, it is unable to comprehend the inquiry. Fig. 2: A document with Shekaru-related information. Note: (This information I have taken from Wikipedia the link for the same Click here) We will now upload this document as it appears in the screenshot below. As seen in the screenshot below, once the document has been uploaded, it will appear in the Upload Document Section. And now that we’ve uploaded the document with Shekaru-related information, we’ll be asking the chatbot questions about Shekaru. We would rephrase the query that the chatbot was unable to respond to the first time. As we ask the same question, “What is Shekaru?” we can see that in the screenshot above. It is capable of providing answers and summaries for the data from the uploaded documents. For the blog, that was all. I sincerely hope you enjoy this blog. If you do, kindly let me know, and feel free to leave a comment with any recommendations. Thank you, Rasik for your valuable insights!
How to Set up OneNote integration in Power apps
Introduction: Enabling OneNote integration to provide the advantage of seamlessly incorporating OneNote for capturing or revisiting customer notes directly within our records. This integration can be configured alongside SharePoint Online, but it requires a Microsoft 365 subscription for leveraging OneNote functionality within model-driven and customer engagement apps. Steps to Turn on OneNote integration. Implementation:
Compose and send email messages using Co-pilot
Introduction: Copilot introduces a feature into Dynamics 365, enriching the user experience and enhancing the functionality of Dynamics for its users. Copilot for Email Features: Enable Copilot Feature: – How to Enable Copilot for Environment How to Use Copilot in Email Messages Thank you, Amisha for your valuable inputs!