Skip to main content

Power BI 支援

搜尋

Re: Report can't connect, but the gateway is online with direct query

Hi @darioconcha,   Please mask your private information like emails, IDs. Did you update the credential in the settings? You can set up the data source. I think the on-premises gate...

Re: Power Bi Dashboard to have customization options

Hi @Priya93,   If you mean the "File" is report. As long as the dataset is refreshed, to make update reflected on the report page, we can click on Refresh button on report page or ...

Re: Cant log in to Power BI pro

Thanks for your answer. But there is no such button as shown in the gif. Even after searching and scrolled down to the end.  Regardless my problem is with signing in. So that I can create a sup...

Re: Comparison of Revenue between same date range in the previous month

Hi @aJ2,   You could follow the steps to get the output below.         1.You should create a Calendar table with the formular below and create the relationships betw...

Best practice to design a Power BI solution

Hi, some years ago, I studied briefly how designing a BI solution by Qlikview and I was hit by creating as a first step an initial QVD file in order to manage inside it the data loading from the var...

Table visual automatically select multiple values

Hi all,   Maybe it's possible, maybe not. I have the following question:   I have a table that looks a bit like this.   Company      Name       ...

Re: DAX

Hi Surya1 ,   To achieve your requirement, you can use DAX formula below: New table = SUMMARIZE(Table1, Table1[col-4], Table2[col-a], Table1[col-5], Table1[col-6], Table2[col-d], Table...

Re: adding a measure to a line chart with a legend

The issue with that one, is that i don't have a [Sales] measure in my table.. i have a column that doesnt need to be split up more.. i am hoping to plot an "x"-number of lines in the background, and...

Re: SSIS Catalog DB Dashboard

Date function uses 'column1' but then it can't find it!!!! Any ideas? Thanks

Simple Formatting Query

Hello i am new to poewr bi and seem to be struggling with what seems a simple matter. When moving from my query to power bi it seems that my formatting gets lost somehow and i cant understand why? ...

Re: Script error when opening desktop

Yes, rolling back to Feb made the script error go away as well, but that means the new features from March and April can't be used till this is fixed. 

A list of top 10 sold products

Hello I have a Query which is call Sales_Data, it has two columns Product_Name and Sales_QTY.   I want a list of the top 10 sold products, what are the steps I need to do to do this?   ...

How do you disconnect a visualization from page filters/slicer

Hello.   I have a slicer and several visuals on a page.  Is it possible to disconnect one visual from the slicer, so that the one disconnected visual does not change as the slicer changes?

Re: Clear All Slicers On Page?

hi @xlnerdy , bookmarch approach helps, but if i have role management included in my dashboard, my reports formatting gets drastically change after applying bookmark, be it clear all or mor...

Disabling api link of a power BI report

Hi All I want to know if there is a way to desactivate or disable the access to the api link of a power BI report ? I have shared somes reports by the past and I want now to monitor the activities ...

Matrix visual not displayed in IE11 - March Release

We have a user still using IE 11 for who the Matrix visual does not load following the upgrade to the March release of PBIRS. Anyone else seen this?   Ctrl+F5 doesnt help.   The IE cons...

Add Hyperlink / URL in report itself when you click on shape/button ?

I have a report which pulls data from an SPO list.   I'd like to add a link back to said SPO site in the report, however, I don't want to do it as a text box but an image, shape, button, or ic...

Re: Displaying Power BI Web Reports As SlideShow

Nevermind this is amazing thank you.

Re: Displaying Power BI Web Reports As SlideShow

Hey @benjaminhoang   Great!!!!!   This error it's because you are not in report page.   Thanks, Hope this extension helps.   

Matrix column value sorting ( aging bucket). Please help

Hi Power Bi Gurus,    I have an aging bucket field with values (0-7 Days, 8-15 Days, 16-30 Days....up to 120+ Days),  and I use a matrix table display the amount by managers by ...

Re: Creating a sequential column with a condition

@GeraSanz11   If your period column is of Date Type you can use following calculated column   Sequential # = RANKX ( FILTER ( Table1, Table1[id_Person] = EARLIER ( Table1[id_Person]...

Re: Add Hyperlink / URL in report itself when you click on shape/button ?

Hi  @OneWithQuestion,   The only option beside the one you have is to create a table with the link you want and then put it on a table visual and choose the link or URL to be shown. ...