Power BI-Support

Suchen

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: DATA MODELLING

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

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.

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: 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...

Re: How to find data sources ?

Hi there You might be able to use the Vertipaq Analyzer to do this, which will show you the size of your tables and the associated columns. https://www.sqlbi.com/tools/vertipaq-analyzer/ I am ...

Authoritative source explaining FIELDS list icons

Hello,   Is there a Microsoft document/link that explains the meanings of different ICONS in FIELDS list in Power BI Desktop?    For example, the below is from "Retail Analysis Sam...

Re: Donut tooltip is not coming in dashboard

Hi @PraveenRaj,   Based on my test, if we pin a report live page to a dashboard, the report page tooltip which contains Donut visual can display fine when we hover on the line chart vis...

Re: ChicletSlicer maximum rows issue

Hi Maggie,  Thanks! I did end up using the default slicer. However chiclet is a lot more dynamic and has some really cool features such as forced selection an picking the visible selections e...

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").&...

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: 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: 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: 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: Customer Retention

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

Re: Split and Transpose in Power Query

I believe you want this:   let Source = Table.FromRows(Json.Document(Binary.Decompress(Binary.FromText("i45WMjEAAiUdJUM9Rz1PPUMwS8EltTixqCg/JycfyDcyMKgxMjCsMbIAEZYQloFSbCwA", BinaryEncod...

Re: Conditionally Insert Row

Worked like a charm!! Thanks very much!

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: 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: 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...