1) Put revenue in one row and have 0s in all others 2) Make single column for cost and revenue. 3) Create two fact tables one for revenue and another for cost.

11 июн. 2022 г. · Solved: Hi everyone, does anyone knows how to achieve this slicer, and what visuals have been used? Thanks in advance for the tips & tricks.

Solved: Hi Wonderful Power BI'ers, I have "general problem" - I'm changing granularity on a lot of fact-tables from event to daily. Meaning.

The most forward solution may be to change from a table to a matrix visual to maintain the drill-down ability while also allowing less granularity as needed.

25 янв. 2021 г. · Scenario: Suppose I want to modify the date in X axis at different granularity based on my requirement, how to achieve it?

I have a line chart and want to know how to set up the data range on Y Axis, now it only shows the gridline with value 0, 50, 100, I just want to add more ...

Solved: I want to show my daily sales, daily stock and monthly sales forecast (which calculated every week) in same table. My tables are connected.

The "milk" granularity exist in the "DIM Material" table, however the tables are connected via "Material". What I need is the following: Whenever there is a ...

20 нояб. 2020 г. · Hi all, i have troubles with modeling in power bi with different granularities. I have two fact tables: 1) Quantity: the table has item_key ...

I basically have to append 2 tables with the same basic structure, but 1 table gives me the "Value" column down to Asset Class granularity, while the other ...