Forum

Sure. Create a dummy PivotTable that contains just the language field in the row labels. When you insert your Slicer you need to connect it to this Pi...

Hi Safirah, You can add a column to your table and use a formula to add the time difference in hours to your Europe time, thus returning the Asia t...

Hi Wen, Please provide a sample file. It's difficult to visualise what you're working with and what your desired result is. Thanks, Mynda

Hi Mark, You can use Sort By to tell Power Pivot to sort a text column (the month names) by a numeric column (the month numbers) as shown in lesson...

Hi Blanka, The balance doesn't make sense. Surely the balance for AAAA as at 6/14 is $17.74 ($2.91 + $14.83) and so on. Also, what date does the...

Hi Wen, There are a few ways to tackle this, some less complex than others: 1. Create two Dashboards, one for English and one for Chinese and se...

Hi Mark, Formatting in Excel has nothing to do with data types in Power BI. I can see in your Excel tables that there are inconsistencies in the co...

Sure will 🙂

Hi Paul, You can't embed Power BI in Excel, only Excel in Power BI. However, there are new custom visuals (charts) coming to Excel. As for Power...

Hi Cory, Another idea is if you don't need to preview all of the queries you can turn off Background Data; go to Query Options > Current Workboo...

Hi Samantha, Try setting the colours to those not from the top row of the palette i.e. choose colours different to the those shown in the PivotChar...

Hi Aurora, The videos don't have clickable links, you'll find the links in the supporting Excel file. Here is the font download link to save you...

Hi Joaquim, Measures are a DAX/Power Pivot term. Power BI uses both Power Query and Power Pivot, although it's less obvious that you're using those...

Hi Carolyn, You can use Power Query Group By to get the desired results too. See attached. Mynda

Hi Anne, Is your source data in Excel, or does it start in a CSV/Text file? Excel is messing up your dates before you have a chance to fix them ...