Поддержка по Power BI

Поиск

Re: Conditionally Insert Row

Worked like a charm!! Thanks very much!

Bug: New Relationship Toggle suddenly not displaying anything

I had created a number of panes and now non of them are working. Everything is just blank. Great Feature, Hopefully we can get it working again. They are not working in any of my reports. Did somet...

Re: Calculate with filter and date

Thanks, I managed to do that but worked for a while.   And what if I have holidays and I never know how many days are going to be off.   I need someway to calculate a date differen...

Re: Sharepoint Connector - Combine Data across multiple Excel Files

Thank you. I understand this, but the problem is my files (data) is not at the top subsite level, it is within a document library, and then two subfolders within that library.  The problem, I be...

Re: Unpivot Multiple Coumns - Desktop

If you have confirmed your email address, you can attach to a post. Otherwise, most people just use One Drive, Box, etc.

Relative relation between two tables

i,   I have 2 sets of tables in my data set - one for Product demand and another for product supply. I would like an output that displays supply based on their availability dates against the d...

Re: Matrix filter on a column values

Thanks that's very useful. However in this case I need to select values so one column could be 0 and another column could be anything over 100. I need to do different combinations based on the column

Re: Inside, into date Interval

Hi @gabrielvigo,   As the Card dispalys only one value which has been aggregated always, we are not able to add a filter condition based on this aggregate value ("Average of Values").&...

Re: Transfer of capacity between entities

Hi @tomprg,   Is this your expected final output? If so, please refer to this measure. Measure = IF ( SUM ( Table3[Capacity] ) < 0, 0, CALCULATE ( SUM ( Table3...

Re: Export to PDF not working

Hi, according to our understanding export to PDF is available in the service from 10th of february. See this blog post.  

Re: Customer Retention

Hi @slyfox,   Please try below measures: No sales in selected Month = IF ( CALCULATE ( SUM ( F_Invoice[Qty] ), FILTER ( ALL ( F_Invoice ), ...

DATA MODELLING

How to learn data modelling for power BI ?

Re: Doubts with INNERJOINs and lineage

@Zubair_Muhammad   And since you like tough questions I have something else regarding the same article on SQLBI. (Disclaimer: I have posted this question there as well, in case you pr...

Re: DATA MODELLING

Have you tried googling? https://docs.microsoft.com/en-us/power-bi/guided-learning/modeling https://www.tutorialspoint.com/power_bi/power_bi_data_modeling.htm https://www.sqlbi.com/p/data-modeling...

Re: Power BI Pro Embedded View on Mobile - Tabs not showing

Hi,   I have answered your questions below.   1 - From within Power BI Desktop we publish to web 2 - Both, ive tested on iPhone 6s+ and Samsung S9+ and get same issues 3 - Within brow...

Re: DATA MODELLING

I would start on this site, up at the top, Learn | Guided Learning. Also, try https://aka.ms/diad.  

Re: Data points on a line chart do not connect when you have multiple values you wish to plot

I created a sample data set and a sample powerBI project but im not sure how to upload it to the thread. Help?

Re: Calculate login count

@alexsimonsson,   To be general, you may refer to steps below:   1. Create a calculate column to achieve the month: Month = MONTH ( Table[created_at] ) 2. Create a slicer based...

Re: Today compared to same day last year

Hi @LisaB,   Have you solved your problem?   If you have solved, please always accept the replies making sense as solution to your question so that people who may have the...

Re: Real Stream Dataset for AZURE SQL Server Database Query Using Powershell

@ashaikh,   This issue is more related to azure sql server, pleae refer to: https://docs.microsoft.com/en-us/azure/sql-database/sql-database-powershell-samples.   Community Support ...

Re: How to know sequence of column used in pivot table

@dipparma1309, I don't think the above requirement can be achieved in Power BI Desktop. It is not possible to determine the column sequence and dynamically show different measure values. Regard...

Re: Power BI Tricky new question

@Baskar   unfortunately, this dataset is very small, as i have only provided the visuals table. i am not in favour of doing this in power query, as this could effect my dashboard.   is...