Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Using SelectedValue with Field Parameter (Prior Period Title Change)

Hi Everyone,   Down below I have my company's sample sales report.  I'm trying to achieve the following: -In the red square, when a value is selected, the title, instead of "Month-1, Month-2", rep...
Need Help
stefan_iceland's avatar
stefan_iceland
Frequent Visitor
2 years ago

Hey, mister bark
I am afraid that this is not a solution to the problem, the problem is that "selectedvalue()" does not work to create a dynamic column header based on a slicer.
"Today()" works fine to make a dynamic column header but in this example it's not based on a slicer so "selectedvalue()" is not used.

mister_bark's avatar
mister_bark
Frequent Visitor
2 years ago

How about this solution? Creating two calculation groups and a field parameters table which are linked?
https://youtu.be/HTIsZLGpFek?feature=shared

The newest update allows calculation groups to be created directly in Power BI desktop which may make this more accessible for folks who do not use Tabular Editor.