Forum Discussion
Post PatronPower BI: Creating a financial model
Hi hidenseek9
Not sure of the values you are putting on the different matrix.
WHat I observe on the third matrix table all other months except September have the Volume(CM) measure as zero. So if you set the visual filter for this measure is not equal to zero , then you get only for September.
Try it out.
Cheers
CheenuSing
Post Patron
Super UserHi,
I got your files but i cannot understand your question.
- hidenseek9
If you open my Power BI dashboard, "CANN Closing", on Page1, I have three matrix.
I am having an issue with the matrix on the far right,
which is shown below.
Basically, in this matrix, what I want to do is to make an adjustment in the matrix.
There are items such as "Mitsubishi (adjustment)" or "Center Fee (adjustment)", that I choose
values from a pull down at the top.
Those are the adjustment that I want to make.
When I choose values from the pull down, the values show up
in all columns (Every single month).
However, since I am only simulating the PL for a month of September,
in this instance, I want the matrix to show just September.
How can I achieve this while I keeping the other two matrix as they are?
Hope the explanation above is clear.
Many thanks,
H
Hi hidenseek9
Not sure of the values you are putting on the different matrix.
WHat I observe on the third matrix table all other months except September have the Volume(CM) measure as zero. So if you set the visual filter for this measure is not equal to zero , then you get only for September.
Try it out.
Cheers
CheenuSing
- hidenseek9
Anonymous
Oh, that was simple enough!
it works.
Thanks,
H