Forum

Hi Laura, It's difficult to be specific as the screenshot doesn't give a lot of information, but I'd structure your data with the following columns...

Hi Tracy, You can post suggestions for product improvements on Power BI's user voice platform. Anyone can post suggestions, they're not restricted ...

Hi Robb, In PivotTables that contain date fields you can right-click the date field > Field Settings > Layout & Print tab > Show items...

Hi Richard, Welcome to our forum! Your image didn't get uploaded properly so visualising your data is a bit tricky. Are you able to try again, or e...

Hi Jesper, Welcome to our forum and thanks for your kind words! I had the same idea to use Sunburst charts, but they aren't customisable enough ...

Hi Warrick, I suspect you also need to change the locale in Excel (File > Options > Language) to match the language settings in your operatin...

Hi Tracy, Correct, Power BI matrix tables don't have the left click and drag manual sorting functionality we have with Excel PivotTables. If you wa...

Hi Christine, Welcome to our forum! Thanks for sharing your example files. Unfortunately, you can't use Power Query to generate the PDFs. If ...

Hi Reehan, I've made some changes, however your example in the file you provided isn't clear, e.g. on the Ledger sheet in row 6 you have a 60,000 t...

Thank you for the example file. First you need to fix the layout of the General Journal data. In the attached file I've used Power Query to extract...

Hi Reehan, Please provide some examples of your desired result in the Ledger sheet. Thanks, Mynda

Hi Amy, You should be using a PivotTable for this. The you can also use Slicersto filter the results on the fly, plus there's no formulas that can ...

Your diagram doesn't indicate the direction of the relationships, but as long as the outer dim tables always filter the inner dim tables and not vice ...

Hi Nesha, You can get the data from the Excel source file with the Power Query tool in Power BI Desktop and then publish to the Power BI service fo...

Your version of Excel doesn't have the option to load directly to a PivotTable, so you will need to choose Load to Table and then insert your PivotTab...