No video
Power BI P&L Report with Option to Hide / Show Columns using Fields Parameter (Alt to Freeze Pane).
Рет қаралды 19,846
Күн бұрынIncorporating a new Power BI feature… newly available in May 2022, New Field Parameter
Can be be an alternatives to those that wants to Freeze Panes in Power BI.
Previously, it was difficult to design a user interface that enable Power BI report user, to select which columns that they want to hide or show in the Power BI P&L report.
For example, in the P&L report, users may want to see comparison vs budget, instead of vs forecast.
or... comparison vs Last year, instead of vs Target...
Some users may also want to see % variance instead of $ variance in the P&L report.
With New Field Paramater.... a newly available Power BI feature, recently released in May 2022, these are all possibilities. Users now have flexibilities, to hide or show columns, by clicking options to display.....
This option can also be an alternative for the lack of FREEZE PANES, to show selected columns, and
Hope you enjoy this video... and learn something useful for you to apply in your future Power BI P&L report.
See you next time.
Cheers,
Isabella Susilowati
#lighthouseanalytix , #worksmarterplayharder, #powerbitutorial, #powerbi, #powerbitutorialforbeginners
LA56
@bharatrajput3565 4 ай бұрын
I have seen 4-5 videos before this, and when I use tricks from these videos, i need to convert my report into import mode but using technique in this video I don't need switch from direct query to import and I got my charm. Thank you
@LighthouseAnalytix 4 ай бұрын
Glad it helped!
@champk996 2 ай бұрын
I have been searching for something similar and this works really well. The explanation is just precise and perfect. Thank you for making our life easier :)
@LighthouseAnalytix 2 ай бұрын
Glad it helped!
@chartdoktor311 Жыл бұрын
Works like a charm, thank you Isabella!
@LighthouseAnalytix Жыл бұрын
you are welcome !!
@mujiangtan3238 Жыл бұрын
loved the demo and the way you explained it, made it so easy:)
@LighthouseAnalytix Жыл бұрын
Glad you liked it!!
@putraschannel795 20 күн бұрын
Tks miss, you're awesome
@PSAndPowerBI 3 ай бұрын
really calm voice,perfect
@LighthouseAnalytix 3 ай бұрын
thank you :)
@SushilDhadse-y4e Ай бұрын
can I have a single option in a slicer to hide/show multiple columns ? for eg. a single slicer option say 'Var' and it show/hides 'Var % TY vs LY' and 'Var TY vs LY' at the same time ?
@tracebuscher379 Ай бұрын
Great video! I was wondering if there is a way to hide columns that are null. Thanks
@jennifersanita1982 10 ай бұрын
Thanks! Is there any way to combine columns for this? for example, my data contains multiple columns for Capital expenses and multiple columns for Operational expenses. I would like three scenarios, 1: show columns pertaining to or containing "CapEx" by selecting "CapEx", 2: show columns pertaining to or containing "OpEx" 3: Show all
@LighthouseAnalytix 10 ай бұрын
Have you considered displaying those selections as rows instead of columns... Then you can use your filter panes on the right to make various selections
@lucasduran3667 3 ай бұрын
OMG Can't thank u enough
@LighthouseAnalytix 3 ай бұрын
you are welcome :)
@Broadmoore Жыл бұрын
Hallelujah this worked! Thank you!
@LighthouseAnalytix Жыл бұрын
Great to hear! So happy for you :)
@LighthouseAnalytix Жыл бұрын
Great to hear! So happy for you :)
@gogomeow 3 ай бұрын
Hi, thank you for making this. I have a request from a user that wants certain columns to be hidden. But the columns used in the parameters still show up even if they were not selected. I guess it is by default.
@kamalgopalsingh244 4 ай бұрын
I have year slicer where I am giving selected year sales and previous year sales customer wise but for first year there is not previous year data then I want to hide last year sales ???How to achieve this any suggestions ????
@MilenaMoravcevic-tr7pw 4 ай бұрын
Thank you so much dear lady :)
@LighthouseAnalytix 4 ай бұрын
No problem 😊
@arghyadutta9091 Жыл бұрын
Great and awesome.
@LighthouseAnalytix Жыл бұрын
Thank you! Cheers!
@ouassimbehlil3557 Жыл бұрын
Thanks, this is helpful.❤️ Keep going!
@LighthouseAnalytix Жыл бұрын
You're welcome 😊
@TheJaebeomPark 2 ай бұрын
great way!
@LighthouseAnalytix 2 ай бұрын
Thank you !!
@vish956 Жыл бұрын
Wonderful
@LighthouseAnalytix Жыл бұрын
Thank you! Cheers!
@user-en3pc7ko8e Жыл бұрын
awesome. super useful!
@LighthouseAnalytix Жыл бұрын
thank you !!
@mohittyagi9141 5 ай бұрын
I have applied the same in my case, but I am not getting total for measures in the down of table. Please suggest
@LighthouseAnalytix 5 ай бұрын
sorry a bit difficult for me to help to trouble shoot without seeing the file. Have you turned on row total option in the table setting?
@enl3299 2 жыл бұрын
Thanks for sharing. Wondering it is possible to have none of the measures displayed. ie unchecking all slicer option will lead to everything showing (no filter)
@LighthouseAnalytix 2 жыл бұрын
Not that I know of... Keen to find out if other people may know some tricks...
@fachrifirdaus1400 Жыл бұрын
My question is, could we disable show data point table on publish report? So, public couldn't see dataset / table behind that visualization. My case is on publish report on website.
@LighthouseAnalytix Жыл бұрын
Are you referring to limiting the ability of report user to download the underlying data from your Power BI Visuals, in Power BI Service? If so, go to File || Options & Settings || Options Then scroll down on the left pane to Current File | Report Settings Then on the right pane, go to Export Data | Select: Don't allow users to export data from Service or Report Server.
@nicoaramihai Жыл бұрын
Great video , keep it up , question : is there a way to enable individual users to save the created configuration/user , so that in the future when they see the report they don't have to remove again the columns. I have 160 columns report and each user is interested in a different subset of those 160.
@LighthouseAnalytix Жыл бұрын
Yes, using bookmark !!! I have several videos on how to use bookmark to save a desired view....
@LighthouseAnalytix Жыл бұрын
kzfaq.infoTTFOmbu7ftc This video is a great introduction to personal bookmark.
@lso4jw251 Жыл бұрын
What if I have several columns that need to stay visible at all times and I want to hide and unhide "ranking" columns. Is there a way to write this to were the slicer does not show the option, but it still stays on the table? Filtering the slicer will hide the selection and will show the column, if you then select all on the slicer. However if you actively select from the slicer the column will disappear.
@LighthouseAnalytix Жыл бұрын
how about if you create two pages... one table with ranking column shown... and another table with ranking coloumn not shown. Then merge them into one page with two tabs (with ranking & without ranking). kzfaq.info/get/bejne/hM1heNydsJ6viIk.html
@philipedesouzasantos1201 Жыл бұрын
After a couple or hours using this feature I noticed some problems with the order when you remove / add new columns. Sometimes this feature is not ordering the columns properly even if you defined the order in script, it ends up putting the category as the last column instead the order defined earlier. Another problem is the drilldown, it doesn't update the table to the bottom level automatically, so the user needs to expand all down in the hierarchy manually. This can be a pain for the final user. :\ This is really a shame, this feature seemed promissing.
@LighthouseAnalytix Жыл бұрын
I haven't come across something like this yet... Pls do share some workaround or solutions if you come across one....
@philipedesouzasantos1201 Жыл бұрын
@@LighthouseAnalytix Sure! Thank you for the reply :)
@SriramJayavel 8 ай бұрын
I have used above format but all numeric fields are changed into Text . Now , Unable aggregate those numeric columns same as Unable change datatype for Text into numeric . Please suggest
@LighthouseAnalytix 8 ай бұрын
Sorry I'm not 100% clear... on the problem that you are experiencing. Can you try converting your data type back to numeric?
@SriramJayavel 8 ай бұрын
@@LighthouseAnalytix Yes i am trying but unable to change text into numeric
@andreatorta451 Жыл бұрын
hello, thanks for the helpfull video. Why, if I follow step by step the video, does my table lose the conditional formatting? Moreover, I am unable to reapply it to the range that includes all the variables. Could you help me?"
@LighthouseAnalytix Жыл бұрын
hm... I haven't tried this yet... keen to hear if you are able to get this sorted
@philipedesouzasantos1201 Жыл бұрын
thanks ma'am :)!!!
@LighthouseAnalytix Жыл бұрын
Most welcome 😊
@satyabobby6248 9 ай бұрын
Thanks a lot.
@LighthouseAnalytix 9 ай бұрын
Most welcome!
@lucadelicio9883 Жыл бұрын
Hi thank you for the video and the explanation. I need to add more difficult. I need to show the column of my table by selecting a value on a different slicer. There is this possibility? If i choose Value1 then the column to display are 1,2,3 if i select Value2 the column to display are 4,5. I can do this with a particular measure? Thank you!
@lucadelicio9883 Жыл бұрын
The solution is to add a column to this structure with the key and connect it to the other table. So when you filter the other table with a slicer automatically you will filter the showed column. Thank you so much!
@LighthouseAnalytix Жыл бұрын
I have never tried that before. Can I assume that 1 may be a relevant columns for Team 1 or situation 2? 2 may be relevant columns for Team 2 or Situation 2? Perhaps also worth exploring: (1) Setting up multiple tabs in a page. Create 1 tab for each team. I have a video about this. studio.kzfaq.infoNg1EylK8KXU/edit (2) Setting up bookmarks that store relevant filter settings. Create 1 bookmark for each team. I also have a video about this. studio.kzfaq.infotoRM2gcNc1Q/edit
@JenkinsChng Жыл бұрын
Can we do this in matrix table? ie I have QoQ and YoY measures, but I only want to show QoQ for last qtr, and YoY for last year, instead of showing all QoQ and YoY columns
@LighthouseAnalytix Жыл бұрын
haven't tried it with matrix yet... please share with us it it words...
@kmedreda Жыл бұрын
Hello , is it available in power bi desktop?
@LighthouseAnalytix Жыл бұрын
yes absolutely
@parikshitkorekar650 Жыл бұрын
Can I add rows in Field Parameters?
@LighthouseAnalytix Жыл бұрын
Absolutely, just modify the dax, and add additional rows
@parikshitkorekar650 Жыл бұрын
@@LighthouseAnalytix can you tell me how?
@SweetPeachannel 3 ай бұрын
orang Indo ya Buk?
@LighthouseAnalytix 3 ай бұрын
Betul :)
@SweetPeachannel 3 ай бұрын
@@LighthouseAnalytix mau donk belajar banyak dari Ibu ...
@user-rk5vo4rc7j 5 ай бұрын
Ummmm, thanks.
@LighthouseAnalytix 5 ай бұрын
:)
@kjames5073 6 ай бұрын
Can this be done for Matrix table as well? I tried for table and it works like a charm, however can you please make one video on doing the same for Matrix table as well?
@LighthouseAnalytix 5 ай бұрын
thanks for the idea... perhaps something that I can explore in the future.
@kjames5073 5 ай бұрын
@@LighthouseAnalytix Thanks you very much mam.
Lighthouse Analytix
Рет қаралды 3,4 М.
Adam Finer - Learn BI Online
Рет қаралды 99 М.
Fernan
Рет қаралды 18 М.
Lighthouse Analytix
Рет қаралды 14 М.
Data For Knowledge
Рет қаралды 24 М.