Relative Content

Tag Archive for powerbipowerbi-desktop

PBI only for visualisation – is my understanding correct?

I have daily data for a period of time for the same set of assets, stored in 100,000 csv files. I want to aggregate the data for any asset selected by the user, and chart various outputs. I chose powerbi for this task.
These 100,000 files are stored in a single table in powerbi (call it ‘Table 1’)
There is another csv file that has asset level attributes, stored as a different table (call it ‘Table 2’). Thus, my powerbi project has two tables – Table 1 and Table 2.
I have created a custom query and charts based on these tables.

How to use KPI cards effectively to showcase comparison for month over month analysis?

I have been finding it difficult to use KPI cards effectively. There are so many types that can be explored to show valuable comparison for month over month or yoy data. I’m a beginner and still learning BI. I understand you have to use DAX to work this out but I’d like to know key step by step process to execute the data. Data set I am currently using is fuel consumption and co2 emission data of aircrafts. Due to sensitivity and confidential data unable to share here. Any tips are well appreciated.

Need help creating two trend lines based on different date columns in Power BI

I have a requirement to show a burn up chart with two trend lines in a line chart in Power BI. First trend line shows the cumulative sum of epics created in a specific year and second trendline should show cumulative sum of epics closed in that specific year. The two trend lines are based on columns – CreatedDate and ClosedDate.

Need help in filtering using measure in power bi

I have 2 measures in my power bi report which show cumulative trend based on two date columns namely created date and closed date. The 2 trend lines show number of bugs created vs number of closed bugs at specific dates.