Relative Content

Tag Archive for powerbidaxpowerbi-desktop

Eliminate customer with less than 2 products from the List

The Power BI report displays customers with a minimum of 2 DS products, as well as those with only 1 DS product. I aim to exclude customers with fewer than 2 products from the list and retain only those with 2 or more products. Could someone assist me in addressing this matter?

Time intelligence calculation DAX POWER BI

I have been trying to calculate the Previous Year amount YTD with no success.
I have been using the following Measure PY actuals to calculate the PY amount in general:

Combining Measures from different Tables

I’m currently building a dashboard that consist of data sources with multiple level of relationship. Some of the tables do not communicate with each other and do not have a relationship that I can combine.

Creating a table with multiple columns that show the count of another column in a separate table at the end of each month

In my created table that we can call table 1, I want to have a column that creates a new row at the end of each month and inside of that cell it will show the count for that month. In table two I will have a month column that says the month and year and the next column is this created dynamic column. It will get the count from a measure in table 2 and on the last day of that month add that count into table one in the next row.

Change fields in visual according to selected value of slicer in Power BI

I am new to Power BI and got stuck at creating a dashboard wherein we are required to change visuals according to selected value of slicer.
If revenue is selected than all the visuals should be in context of revenue and if profit is selected, all should be of profit.
I’ve done the required using buttons and bookmarks, however, while using field parameter I am not able to change the values of clustered bar chart.Select a value Visual should be according to the selected value