Stack Overflow
Stack Overflow

Questions tagged [powerbi-datasource]

622 questions
0
votes
1 answer

How to display data from different data source tables in a single table in Power BI

I have a couple of different tables in my Report, for demonstration purposes lets say that I have 1 data source that is Actual Invoice amounts and then I have another table that is Forecasted amounts. Each table has several dimensions that are the…
Paul Cavacas
  • 4,194
  • 5
  • 31
  • 60
0
votes
1 answer

How to load a data source to a gateway from public server postgres Database?

I am trying to connect data-source to PowerBI Gateway from a public virtual machine, the data source is Postgresql. I had installed gateway on the same machine and tried to connect a new data source in the web and then given all the details to…
Antony Joslin
  • 309
  • 4
  • 17
0
votes
1 answer

Create column in matrix that is a ratio of the values of two other columns in Power BI

I have a matrix that has the total premiums for each year, and total commissions for each year. I would like a third column that shows what the ratio for total commissions to total premiums is for each year. I thought this would be easy but the…
Raphaël Briand
  • 1
  • 2
0
votes
1 answer

how not to display YOY percentage change if its -100% Power BI

I have a Stalked Column Chart that displays 12 months Year over Year comparison. If I look at the data using table - then it looks fine, we have value for January 2018 only, and the rest are blank. But if I put it on a chart - it shows negative…
Serdia
  • 4,242
  • 22
  • 86
  • 159
0
votes
1 answer

Month of previous year doesnt go away when selecting a new year Power BI

I have two slicers in my report. Year and 12 months. If I look at the data by selecting year only, months are changing fine, according to year. But if I choose Year 2017 and, lets say, December month, and then switch to Year 2018 - it will…
Serdia
  • 4,242
  • 22
  • 86
  • 159
0
votes
0 answers

How to create a flag based on two time based measures?

I have a Power BI file with 4 tables. Customer, Calls, Repairs and Date. I have calculated Total Calls, Previous Month Calls, Total Repairs and Previous Month Repairs. How do I create a flag to catch customers who have calls more than the previous…
Chat Peters
  • 39
  • 3
0
votes
3 answers

PowerBI Hide 0 Values in the Page | PowerBI

Could someone advice how could be hide 0 values from all chars on the PowerBI page? For example when I clicking on chart A and want to filter just specific Axis, report filtering data on chart B, but also shows me lines with 0 values. How could be…
Key
  • 71
  • 1
  • 9
0
votes
2 answers

Can we use both Direct Query and import option in a single Power BI Report?

I'm Trying to create a Power BI Report where I have Two data Sources. One is a SQL Server Database and the other is an excel file. I was wondering If I could import the Excel File and get the data from the SQL server database using a Direct…
Vishnu Suresh
  • 157
  • 1
  • 5
  • 21
0
votes
0 answers

Power BI - Reloading data on a page dynamically

I would like a way to change report data dynamically on a Power BI page. Is it possible to insert an input component to load one Excel file in a page generated by Power BI, so all visual components automatically show it? If not, how can I accomplish…
felipe.zkn
  • 2,012
  • 7
  • 31
  • 63
0
votes
2 answers

Converting Decimal to Binary Power bi

I have a column name Config which contains decimal number 1 to 14. I want to create a new column config2 and convert config column into binary (base2). eg. config2 =(config binary (base2)) *Config |Config2* 1 |0001 2 |0010 3 …
Joyo Waseem
  • 680
  • 8
  • 25
0
votes
1 answer

Power Bi Matrix Table "Go to the next level in hierarchy (Button)"

I have an issue with drilling down the Metrix table "Go to the next level in the hierarchy (button)" is not making any sense to me as per my data. Here is how my Data looks like. Here is the default result of my Matrix Table. Here is the level 1…
Joyo Waseem
  • 680
  • 8
  • 25
0
votes
2 answers

How to control decimal precision on Power BI's DAX

Lets say I have a table "Table1" with field Field1, "Table2" with Field2. I have another calculated column in "Table1", "CField" that has formula : CField = ROUND(Table1[Field1] * RELATED(Table2[Field2]); 2) The formula works well overall, except…
Ken Bourassa
  • 6,363
  • 1
  • 19
  • 28
0
votes
1 answer

Dynamic title not displaying in POWERBI

I am new to PowerBI. I was trying to create a dynamic title for my POWERBI project. I went through some videos. All videos asks me to create measure. I did as the video suggested and the code that I put in was: Measure =…
yoyo yagami
  • 257
  • 1
  • 5
  • 18
0
votes
2 answers

Replace in Power BI

I have the below two tables imported to power bi from SQL database:
yogesh puttaswamy
  • 71
  • 1
  • 1
  • 10
0
votes
1 answer

MultipleLines custom field in VSO does not appear in Power BI report's dataset

I referred the Link to import the data from my VSO into a Power BI report. I'm able to view all the Fields data related to a Work item (ex: title, assigned to, state) in 'WorkItems' table. I'm also able to view the Custom fields data as shown…
yogesh puttaswamy
  • 71
  • 1
  • 1
  • 10
1 2 3
…
41 42